thanks for your help
I got my work done
ritesh
On Mon, 2005-12-05 at 17:11, Rob Lohman wrote:
> It seems we are both right :)
>
> sqlite> create table test (filename varchar(1000) primary key);
> sqlite> insert into test (filename) values ('test');
> sqlite> select * from test where filename='test';
> test
> sqlite> select * from test where filename='tesT';
> sqlite> select * from test where filename like 'tesT';
> test
> sqlite> insert into test (filename) values ('testing');
> sqlite> select * from test where filename like 'tesT';
> test
>
> In other words, when doing field = 'value' it is case sensitive,
> with a field like 'value' it isn't. If you don't use '%value%' it
> will do an exact match (it seems).
>
> This was tested on 3.2.1
>
> ----- Original Message -----
> From: "Brandon, Nicholas" <[EMAIL PROTECTED]>
> To: <sqlite-users@sqlite.org>
> Sent: Monday, December 05, 2005 12:15 PM
> Subject: RE: [sqlite] Regarding String Comparision
>
>
> >
> > Rob/Ritesh
> >
> >>Also keep in mind that such a search is CASE SENSITIVE.
> >>There are two solutions to that, either makes the collation
> >>case insensitive or do a:
> >
> > I don't have access to SQLite immediately but I seem to remember in one of
> > my applications that the use of
> >
> > select * from test where filename like '%file%';
> >
> > would return string that are case INsensitive. (ie 'file', 'FILE', 'File'
> > ...)
> >
> > Ritesh I would suggest that you confirm this before relying on it.
> >
> > Regards
> > Nick
> >
> > ********************************************************************
> > This email and any attachments are confidential to the intended
> > recipient and may also be privileged. If you are not the intended
> > recipient please delete it from your system and notify the sender.
> > You should not copy it or use it for any purpose nor disclose or
> > distribute its contents to any other person.
> > ********************************************************************
