How to search for %

From: Shaw, John B <jbshaw_at_ingr.com>
Date: Wed, 18 Oct 2000 14:18:47 -0500
Message-Id: <10653.119697@fatcity.com>

I need to find a '%' in char field (8.05) and I can't seem to figure out the right sql to get it - the following are what I've tried so far (\ is the escape).

SQL> select * from test where a like '\%'; A

---

ab%cd
abcd
efgab

SQL> select * from test where a like '%\%%'; A

---

ab%cd
abcd
efgab

SQL> select * from test where a like '%\%'; A

---

ab%cd
abcd
efgab

SQL> select * from test where a like '\%%'; A

---

ab%cd
abcd
efgab

.... . .-.. .--. .. ...- . -... . . -. .--. .-. --- -... . -.. John B. Shaw
Intergraph Public Safety
mailstop LR24A4
jbshaw_at_ingr.com
256-730-8038
All the usual disclaimers and some of the certifications Received on Wed Oct 18 2000 - 14:18:47 CDT