Hello, I would try
select '>' || trunc(fixfld) || '<' from table It's not tested, but I think this should do the job. Cheers Peter > -----Urspr�ngliche Nachricht----- > Von: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED] > Gesendet am: Mittwoch, 17. September 2003 13:47 > An: [EMAIL PROTECTED] > Betreff: 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< > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
