Can you search SQL this way?

Phil (OmnisList) phil at
Fri Oct 22 14:36:44 UTC 2021

Hi Das,

the string needs quotes...
field like '%string%'

A list?
That is not a SQL object.
What is that stored as? is it binary? so basically no chance of looking 
up on that.

Phil Potter
Based in Chester in the UK.

On 22/10/2021 15:18, Das Goravani wrote:
> Hello Listers,
> I’m wondering about two SQL searches or selects.
> One is if you have a large field full of text, and you want to search for a string inside it. Do you use LIKE %sring% ?
> And if you have a list, and you want to select on a value in a column, can you do that?
> That’s it.
> Thanks
> Das Goravani
> _____________________________________________________________
> Manage your list subscriptions at
> Start a new message ->mailto:omnisdev-en at  

More information about the omnisdev-en mailing list