Numeric Operators in SQL Where clauses
On Feb 2, 2018, at 17:20, Das Goravani <email@example.com> wrote:
> I have a where clause which searches multiple fields from one text entry field.
I recommend building a server-side function to handle this. This will mean a single roundtrip to the database. If you try to run all the SQL from Omnis, you’ll get a network hit for each additional column you search.
This also lets you encapsulate the search logic and handle interesting cases like numbers, dates, booleans, etc.