Numeric Operators in SQL Where clauses

Hi Das,

Can you explain why you want to do this? If (for example) you COULD ask for all records where a numeric field begins with the number 6, you would get 6, everything in the 60’s, everything in the 600’s, everything in the 6000’s, etc. Why would you ever want this?

Jim

>
>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

—
Jim Pistrang
JP Computer Resources
413-256-4569
<www.jpcr.com>

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