Re: [sqlite] how to search for asterix character?

Glob works fine as well with the [*] and is still case-sensitive and that is how it is intended. So this works fine: select field1 from table1 where field1 glob '*FH*[*]' RBS On Wed, May 26, 2010 at 8:22 PM, Olaf Schmidt wrote: > > "Bart Smissaert" >

Re: [sqlite] how to search for asterix character?

"Bart Smissaert" schrieb im Newsbeitrag news:aanlktikivzcbz81hqs28dtptoy8h6hc6nbukesmth...@mail.gmail.com... > > "...Where SomeColumnContent Like '%someother[*]part%' > > Thanks Olaf, that works fine. > As my customers won't get this I think I might let my > code take

Re: [sqlite] how to search for asterix character?

>I use vb or in SQLlite Expert the * does not seem to work > >From my testing * doesn't seem to work in the likeif I use '%33' it > returns >everything with test33if I use '33%' it returns everything with >33testif I >use '%33%' it returns everything with 33test, test33 which is the same as >*

Re: [sqlite] how to search for asterix character?

> "...Where SomeColumnContent Like '%someother[*]part%' Thanks Olaf, that works fine. As my customers won't get this I think I might let my code take care of this. How would it work with glob? RBS On Wed, May 26, 2010 at 7:05 PM, Olaf Schmidt wrote: > > "Bart Smissaert"

Re: [sqlite] how to search for asterix character?

"Bart Smissaert" schrieb im Newsbeitrag news:aanlktil5lha-3-l6x8umwv8e3pyrda6h0ln3dcoyh...@mail.gmail.com... > Yes, it must be either my code or the wrapper to blame. > Thanks for confirming. It's a wrapper-"problem", but a perhaps a coding problem as well... ;-) The

Re: [sqlite] how to search for asterix character?

ack > Senior Scientist > Northrop Grumman Mission Systems > > > > > From: sqlite-users-boun...@sqlite.org on behalf of ro...@zhole.com > Sent: Wed 5/26/2010 12:14 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] how to search for asterix

Re: [sqlite] how to search for asterix character?

nesday, May 26, 2010 12:54 PM > To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> > Subject: Re: [sqlite] how to search for asterix character? > >>How do I search for the asterix character *  ?? >> >>This doesn't work: >>select

Re: [sqlite] how to search for asterix character?

which is the same as * Hope this helpsRoger From: "Jean-Christophe Deschamps" <j...@q-e-d.org> Sent: Wednesday, May 26, 2010 12:54 PM To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Subject: Re: [sqlite] how

Re: [sqlite] how to search for asterix character?

ope this helpsRoger From: "Jean-Christophe Deschamps" <j...@q-e-d.org> Sent: Wednesday, May 26, 2010 12:54 PM To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Subject: Re: [sqlite] how to search for as

Re: [sqlite] how to search for asterix character?

Yes, thanks, it looks it might indeed be the (VB) wrapper that is to blame here. Will contact the developer. RBS On Wed, May 26, 2010 at 5:53 PM, Jean-Christophe Deschamps wrote: > >>How do I search for the asterix character *  ?? >> >>This doesn't work: >>select field1 from

Re: [sqlite] how to search for asterix character?

>How do I search for the asterix character * ?? > >This doesn't work: >select field1 from table1 where field1 like '%FH%*%' >as the * character here seems to be ignored. > >Using the latest version of SQLite. You're doing it right. Either you use a wrapper that messes with * in litterals or

[sqlite] how to search for asterix character?

How do I search for the asterix character * ?? This doesn't work: select field1 from table1 where field1 like '%FH%*%' as the * character here seems to be ignored. Using the latest version of SQLite. RBS ___ sqlite-users mailing list