How to convert #DECIMAL into #VARCHAR when part after decimal separator is not needed and you don't want trailing dot in the end of string in #Teradata ? Use CAST(CAST(9.00 AS FORMAT 'Z(I)') AS VARCHAR(50)) #sql #tip