Archives of the TeradataForum

Message Posted: Wed, 11 Jul 2007 @ 16:13:26 GMT

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

Hi Craig

You need to use character_length instead of length

     SELECT character_length (tracking_no_merge)
     FROM orderstat.tracking_no_TMP
     WHERE character_length (tracking_no_merge) > 200;

Regards

Di

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