Re: Spaces after value in a CHAR(10) item

try select rtrim(<my_column>) into <my_variable> ...

Dave

On 26 Jan 2001 13:18:09 GMT, jperret_at_freesurf.fr (PERRET) wrote:

>Hi,
>
>I got a DB column (CHAR(10)) and want to get her value on a variable.
>I tried a cursor, and a "select <my_column> into <my_variable> ...", but I
>always get my value plus spaces completing to 10. Sample : if my value is
>"0001" i get "0001 " !!!
>How can I retrive my value WITHOUT the spaces ??
>
>Thanks by advance,
>
>Jerome
Received on Mon Feb 05 2001 - 01:23:46 CET