Can you search SQL this way?

Das Goravani goravanis at
Fri Oct 22 14:39:51 UTC 2021

Yes, the list is an Omnis list stored in SQLite. The data type you use is LIST when making new columns for an Omnis list.

I realize it may not be a SQL object or searchable.. was just wondering. 

I can always SELECT USING SQL objects, load a list of returned rows, and run down them in Omnis searching the contained lists if need be. 

> On Oct 22, 2021, at 10:36 AM, Phil (OmnisList) via omnisdev-en <omnisdev-en at> wrote:
> 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 at
>> Start a new message ->mailto:omnisdev-en at  
> _____________________________________________________________
> Manage your list subscriptions at
> Start a new message -> mailto:omnisdev-en at 

More information about the omnisdev-en mailing list