Archives of the TeradataForum
Message Posted: Thu, 10 Jun 2004 @ 08:31:57 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|