Yes, it must be either my code or the wrapper to blame.
Thanks for confirming.
RBS
On Wed, May 26, 2010 at 6:18 PM, Black, Michael (IS)
<michael.bla...@ngc.com> wrote:
> This works for me:
>
> sqlite> create table t(t varchar);
> sqlite> insert into t values('Testing*with asterisk');
> sqlite> insert into t values('Testing without asterisk');
> sqlite> select * from t;
> Testing*with asterisk
> Testing without asterisk
> sqlite> select * from t where t like '%*%';
> Testing*with asterisk
>
> Michael D. Black
> 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 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
> *
> 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 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 there is actually no matching row. Try using the
> command-line tool to better diagnose what's going on here.
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
