Archives of the TeradataForum
Message Posted: Mon, 15 Sep 2003 @ 14:54:53 GMT
Subj: | | Looking for Apostophes in character fields |
|
From: | | Barham, William |
If I search for a specific name (e.g. D'Arcy) with an embedded apostrophe, I can find it by repeating the apostrophe
i.e. Select * from customer_table where cust_name ='D''Arcy' ;
But I get no match if I code it with a LIKE statement i.e. Select * from customer_table where cust_name like 'D''Arcy' ;
How would I look for all customers who have an apostrophe in the cust_name field?
Bill Barham
Senior Data Analyst
|