Archives of the TeradataForum

Message Posted: Mon, 15 Sep 2003 @ 14:54:53 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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

	<Prev	Next>		<<First	<Prev	Next>	Last>>