Can you search SQL this way?

[Phil (OmnisList)]

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.

regards
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 athttp://lists.omnis-dev.com
> Start a new message ->mailto:omnisdev-en at lists.omnis-dev.com