Numeric Operators in SQL Where clauses
> On Feb 2, 2018, at 2:23 PM, Alex Clay <firstname.lastname@example.org> wrote:
> 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.
At my early stage I can’t say I know what a server side function is, though I’m aware of names that are on the server like ‘views’, ‘stored procedures’. I imagine you mean something along those lines. I don’t know how to do those yet at all. I’m just getting rolling with the most basic windows, functions on those windows, etc. I look forward to being more literate in SQL. If you want to tell me more you’re welcome to but I am brand new to what you’re speaking about.