Archives of the TeradataForum
Message Posted: Mon, 15 Sep 2003 @ 14:54:53 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|