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

PERRET wrote:

> 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> ...", bu
 t 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 ??

SELECT RTRIM(COL) or, better, declare column as VARCHAR2 instead of CHAR. HTH, Cris

-- 

Cristian Veronesi ><(((( > http://www.crpa.it

[Quoted] If Bill Gates had a dime for every time a Windows box crashed...
Oh, wait a minute... he  already  does! ;)