Numeric Operators in SQL Where clauses
> On Feb 2, 2018, at 2:13 PM, Jim Pistrang <firstname.lastname@example.org> wrote:
> 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?
I have a where clause which searches multiple fields from one text entry field.
So if they type S they get all the Sams and Stevens and I want it to not crash because there is also a numeric field being searched and that is the sequence field.
It’s in trying to search both character and numeric in one where clause that the problem arises. Postgres is barking at me. If I handle the numeric field in the normal numeric way, lets say using = then it barks when I type a letter.
It’s in trying to use one search field, search multiple fields of differing types, and get one list, that my problem arises. I could solve it by having 2 selects, append the results, and remove duplicates.
Manage your list subscriptions at lists.omnis-dev.com
Start a new message -> mailto:email@example.com