Archives of the TeradataForum

Message Posted: Sat, 05 Feb 2011 @ 20:59:01 GMT

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

I do not understand whether you want to delete (Trim) or add trailing spaces.

If the table has the attributes as a VARCAHR then trailing spaces are unlikely but you might add them with SELECT CAST(columnname as CHAR(fixed_length)).

If a CHAR of fixed length then spaces pad the core characters in which case SELECT TRIM(columnname) will drop leading and trailing spaces. Note that numbers including dates can be formatted - Teradata Format is an extension of the ANSI Format and works differently. Try SELECT columnname (FORMAT '99999999') or (FORMAT 'YYYY-MM-DD')

Any or all of these could and should be incorporated in the View accessed for the BI report

Kenneth Hansen

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