Re: Better Way around the barn

From: AK <steven.kuzine_at_gmail.com>
Date: 6 Jul 2005 10:40:28 -0700
Message-ID: <1120671628.044004.255720@g14g2000cwa.googlegroups.com>

create table a(i varchar2(10))
Table created

insert into a values(' 512')
1 row inserted

insert into a values(' 513')
1 row inserted

insert into a values(' 52')
1 row inserted

insert into a values(' 612')
1 row inserted

select '!'||i i from a
I

---

! 512
! 513
! 52
! 612

4 rows selected

update a set i=ltrim(i) where i like ' 5%' 2 rows updated

select '!'||i i from a
I

---

!512
! 513
!52
! 612

4 rows selected    

drop table a
Table dropped Received on Wed Jul 06 2005 - 12:40:28 CDT