Re: fixed and string concatenation

Hannu Krosing <[email protected]> Wed, 17 Sep 2003 16:53:22 +0300

Newsgroups	gmane.comp.db.sapdb.general
Message-ID	<[email protected]>

Валерий Жученко kirjutas K, 17.09.2003 kell 14:46:
> Hi.
>  
> How I can receive the following result from
>  
> select '>' || fixfld || '<' from table

try: select '>' || floor(fixfld) || '<' from table

or: select '>' || round(fixfld) || '<' from table

> >8<
>  
> Where fixfld = 8 for example and fixfld is fixed (5,2).
>  
> I receive >8.00<
--------------
Hannu