[4VRB] Can't do LIKE search for \

[jda]

Hi Ruslan,

I reported this about 6 months ago. Now my users are reporting it.

SQL LIKE searches of indexed text fields for the \ character fail:

        select * from references where title LIKE '\\'

doesn't work (whether or not I escape the backslash, as above).

Looks like a bug to me, but perhaps there's a workaround.

Jon

P.S. I need to be able to do this kind of search because the 
backslash indicates a subscripted character in my text.