Numeric Operators in SQL Where clauses

Hi Das,

You need to cast the numeric field to a character type. For PostgreSQL:

> WHERE prod_id::text LIKE ‘[isearchtext]%’

Alex

> On Feb 2, 2018, at 16:04, Das Goravani <das@goravani.com> wrote:
>
>
> Hi
>
> It’s OK to do this
>
> WHERE prod_name LIKE ‘[isearchtext]%’
>
> But not with numeric fields, in this case prod_name is character, and it works
> But if I try LIKE with a numeric field, it doesn’t work
>
> What is the equivalent or nearly similar for numeric fields
> Where you want to say “It begins this way”
>
> Thank you
>
> Das
> _____________________________________________________________
> Manage your list subscriptions at lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com

_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com
Start a new message -> mailto:omnisdev-en@lists.omnis-dev.com