Archives of the TeradataForum

Message Posted: Thu, 10 Jun 2004 @ 08:31:57 GMT

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

Hi all,

I need to CAST a decimal column as a left-justified character string. I've tried the CAST function, but the result has a period at the end.

For example, when I do: select cast(server_num as char(16)) as server_locator

The result string is: "123456." (with the period at the end).

I guess this has something to do with a default format. Can anyone help me with this?

Thanks,

Bob

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