Re: How to escape % character in LIKE clause

From: skv <skv_at_kpbank.ru>
Date: Sat, 2 Jan 1999 16:04:28 +0700
Message-ID: <76kmqk$e69$1@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 - 03:04:28 CST