Re: [?] pl/sql string function

you can try:
insert into <table> (pippo) values (lpad('ABC',8));

--
Regards
Michel

Poguedauff <pogue_at_pogue.it> a écrit dans le message : 7vp688$ed2$1_at_fe2.cs.interbusiness.it...
> I am trying to write an SQL statement that insert in the leftmost part of a
> varchar2 n blanks where n is the length of the field minus the existing
> characters of the field.
> An example:
>
> field name = pippo
> field size = 8 (varchar2)
> field value = 'ABC'
>
> what I want the field value to be is = ' ABC'
>
> Did anybody have the same problem? Any suggestion (specially for inserting n
> blanks , I know how I can calculate the n value withe the length function)?
>
> Thanks in advance to everybody.
>
>
>
>
Received on Wed Nov 03 1999 - 07:00:10 CST