Archives of the TeradataForum

Message Posted: Mon, 15 Sep 2003 @ 15:13:40 GMT

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

You need to include wildcards in the like statement for it to pickup a string containing the value you want - in your example it should be -

Select * from customer_table where cust_name like '%D''Arcy%' ;

Extending that, if you want anyone with an apostrophe you would use

Select * from customer_table where cust_name like '%''%' ;

Regards,

Stuart

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