Re: fixed and string concatenation

Валерий Жученко huet geschriwen:

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

not tested but try:

select '>' || chr(fixed(fixfld,5,0)) || '<' from table
or
select '>' & chr(fixed(fixfld,5,0)) & '<' from table

I also didn't found the fixed function in the documentation but for a 
float it worked

Georg