Archives of the TeradataForum

Message Posted: Tue, 09 Aug 2011 @ 07:50:00 GMT

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

Hi,

The answer below covers your 'compare' question.

The otehr part of the answer is about storage. You have defined the column as CHAR(3) so (ignoring compression) it holds 3 characters. If you only fewer characters when inserting the row then Teradata will pad it with spaces.

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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