Archives of the TeradataForum

Message Posted: Wed, 05 Nov 2003 @ 20:34:37 GMT

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

You can also do the following:

SELECT *
FROM user_names
WHERE last_name = "O'GRADY"c;

Putting the string in double quotes immediately followed by the 'c' character will treat everything within the quotes as a character string literal.

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