Re: How to escape % character in LIKE clause

In the where clause you also have to explicitly specify '\' as the escape character. The exact syntax is:

...WHERE field like '\%' ESCAPE '\'

Eric Ma

skv <skv_at_kpbank.ru> wrote in message news:76kmqk$e69$1_at_home.kpbank.ru...
>zoaibs_at_my-dejanews.com пишет в сообщении <76kjqd$6ha$1_at_nnrp1.dejanews.com>
...
>>Can some one tell me how to search for a field value which contains %; I
mean
>>how to escape % in LIKE clause TIA
>>
> hi
>Just place backslash before %(WHERE fld like '\%')
>
>Regards
>-------------------------
>Konstantin V. Sartakov
>Kuzbassprombank, Kemerovo, Russia
>mailto:skv_at_kpbank.ru
>
>
>
Received on Sat Jan 02 1999 - 19:48:19 CST