Archives of the TeradataForum

Message Posted: Wed, 11 Jul 2007 @ 16:36:40 GMT

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

LENGTH is an ODBC function; it is not available in BTEQ.

Try to replace it with something like CHARS:

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

Are you on a very recent release? The error message used to be different.

Regards,

Victor

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