Re: [sqlite] Question about LIKE

2007-02-26 Thread drh
"Doug" <[EMAIL PROTECTED]> wrote: > I appologize if this has been answered--haven't found it in the docs, wiki > or mail archive. > > I have a text column with the following text value in it: > c:\Temp\Temp1\Audit1.log > > I'm trying to figure out how LIKE works. When using the following pattern

[sqlite] Question about LIKE

2007-02-26 Thread Doug
I appologize if this has been answered--haven't found it in the docs, wiki or mail archive. I have a text column with the following text value in it: c:\Temp\Temp1\Audit1.log I'm trying to figure out how LIKE works. When using the following patterns, I get the following results: '%audit%'