Re: Database Queries (gurus - Help needed)
From: Gayatri Sriram <gsriram_at_ix.netcom.com>
Date: 1995/08/20
Message-ID: <417sql$1ab_at_ixnews5.ix.netcom.com>#1/1
Date: 1995/08/20
Message-ID: <417sql$1ab_at_ixnews5.ix.netcom.com>#1/1
In <DDH3Es.Fp3_at_pfizer.com> ywu <ywu.pfizer.com> writes:
>
>
>Hi,
>
> try to do
>
> update table_name set name=substr(name,3,10)
>
> if your table looks like
>
> table_name(name varchar2(10))
>
> good luck !
>
>
>Yong,
>
How about the following ?
update table_name set name=substr(name,3,length(name)-2);
This way we do not have to worry about the column length.
>
Received on Sun Aug 20 1995 - 00:00:00 CEST