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
