Thanks Martin Thats exactly what I wanted to know. And I think this is the fastest reply/solution I ever got!!
ritesh On Mon, 2005-12-05 at 14:36, Martin Engelschalk wrote: > Hi, > > I am not sure if i understand your question right. Perhaps the following > will help: > > The behaviour depends on the comparison operator. > > If you do > > select ... > from FileTable > where FileName = "testfile.txt" > > then the whole string will be matched > > If you do > > select ... > from FileTable > where FileName like "%/testfile.txt" > > then you would get all files named "testfile.txt" regardless of their > path. sqlite will search for strings ending in "/testfile.txt". > > Martin > > Ritesh Kapoor schrieb: > > >Hi, > > > >I am debugging a program which has a FileTable field called FileName > >declared as- > > > >"FileName varchar(1024) primary key" > > > >It stores filenames including their paths e.g. - "myDir1/testfile.txt" > > > >If I were to search in this FileTable in the column FileName for a > >string "testfile.txt" would it return me the row "myDir1/testfile.txt"? > > > >I'm not sure about this but currently I think this is what is > >happening. Is this the default behavior of SQLite? > > > >Are there any setting which would make it match the whole string? So > >that I don't have ambigious situations where two rows might match to the > >same search string. > > > >Thanks & Regards, > >ritesh > > > > > >