RE: fixed and string concatenation

[Schroeder, Alexander]

At least you can do:   SELECT '>' || truncated_fixfld || '<' FROM (SELECT TRUNC(fixfld) as truncated_fixfld FROM table)   if you want simple truncation (although even this looks a little bit ugly).   If you want, e.g. 8.00 as 8 and 8.10 as 8.1 and 8.13 as 8.13 you may use   select '<' || RTRIM(RTRIM(fixfld,'0'),'.') || '>' from table   Regards   Alexander Schröder SAP DB, SAP Labs Berlin -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 1:47 PM To: [EMAIL PROTECTED] Subject: fixed and string concatenation Hi.   How I can receive the following result from   select '>' || fixfld || '<' from table   >8<   Where fixfld = 8 for example and fixfld is fixed (5,2).   I receive >8.00<