Archives of the TeradataForum

Message Posted: Mon, 15 Sep 2003 @ 15:29:35 GMT

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

Check the data type of your field. If it is a char(x), then 'like' will not truncate the trailing spaces and you'll have to add a '%' to the end of your search (This is usually a good idea with searches anyway). If the field is a varchar then the trailing spaces shouldn't matter.

Jason

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