Re: PL/SQL functions

Try this (example from SQL*Plus):

select lpad ('test',10,'a') from dual;

LPAD adds 6 'a' to the string 'test' (6 = 10 minus length string 'test'). Replace 'a' with spaces
and your problem is fixed.

Kind regards,

Maurice

Sandy wrote in message <176f8e61.25ce56b4_at_usw-ex0110-076.remarq.com>...
>hi,
>
>I found for the leading zeros it is with to_char for numbers
>with the format 0999... but how can i do if the data
>contained in my variable is not a number like 'hello' if i
>want it to be ' hello' how can i do ?
>
>thanks
>
>Sandy
>
>
>* Sent from AltaVista http://www.altavista.com Where you can also find
related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful Received on Fri Aug 25 2000 - 14:34:35 CEST