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 Octob
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 for
> 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% of it' as value union all
se
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%'),
...>
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
http://sandersonforensics.com/forum/
> 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 evaluate to a string consisting of a
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 this
7 matches
Mail list logo