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

[Ruslan Zasukhin]

on 3/17/03 2:52 PM, jda at jda at his.com wrote:

Hi John,

> 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.

Problem only with SINGLE '\\' back slash,
Or such string 'aaa\\bbb' also not work ?

I assume this can be reproduced with simple few records table and VAPP...

Okay, let's keep in mind this report for now.

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

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------