> On Oct 5, 2016, at 11:50 AM, Paul Sanderson <sandersonforens...@gmail.com> > wrote: > > How do I search for a % symbol within a string when % is a wild card > and I am escaping that very wildcard?
For example: with DataSet as ( select 'I got 20 quid' as value union all select 'i got 20% of it' as value union all select 'i got just 20%' as value union all select 'some money' as value union all select 'this is an underscore _ ok' as value ) select value from DataSet where value like '%\%%' escape '\’; i got 20% of it i got just 20% _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
