AW: fixed and string concatenation

"Hübschen, Peter" <[email protected]> Wed, 17 Sep 2003 14:30:01 +0200

Newsgroups	gmane.comp.db.sapdb.general
Message-ID	<5037282E0DC5D711974C00304852417A025E82@SERVER-XCH>

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<
>