Re: [sqlite] Searching for a percent symbol

Thank you also Petite Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence On 5

Re: [sqlite] Searching for a percent symbol

Brilliant thansks Dominique - I had completely misunderstood it :) Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address

Re: [sqlite] Searching for a percent symbol

> On Oct 5, 2016, at 11:50 AM, Paul Sanderson > 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%

Re: [sqlite] Searching for a percent symbol

On Wed, Oct 5, 2016 at 11:50 AM, Paul Sanderson < sandersonforens...@gmail.com> wrote: > Thanks Petite - I have already looked at that - but how? > sqlite> create table t (v); sqlite> insert into t values ...> ('I got 20 quid'), ...> ('i got 20% of it'), ...> ('i got just 20%'), ...>

Re: [sqlite] Searching for a percent symbol

Thanks Petite - I have already looked at that - but how? How do I search for a % symbol within a string when % is a wild card and I am escaping that very wildcard? Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786

Re: [sqlite] Searching for a percent symbol

> On Oct 5, 2016, at 11:38 AM, Paul Sanderson > wrote: > > How casn I find just the rows containing the percent symbol? is it possible? Use the ESCAPE clause: "If the optional ESCAPE clause is present, then the expression following the ESCAPE keyword must

[sqlite] Searching for a percent symbol

Hi all I have a column of string values some of which may contain % characters Is it possible to search for just those rows that contain a % eg how could I search for 20%. on a test table containing: I got 20 quid i got 20% of it i got just 20% some money this is an underscore _ ok I tried