Re: [Q] CHAR to VARCHAR2
From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1996/12/01
Message-ID: <57qtjn$6ei_at_newton.pacific.net.sg>#1/1
Date: 1996/12/01
Message-ID: <57qtjn$6ei_at_newton.pacific.net.sg>#1/1
"Rene L. Rodriguez" <bz176_at_freenet.buffalo.edu> wrote:
>
> Is there a function such as VARCHAR2("char variable") to convert
>CHAR variables to VARCHAR2 variables??
>
>
>--
>Rene L. Rodriguez
>bz176_at_freenet.buffalo.edu
>rodrrl13_at_snybufaa.cs.snybuf.edu
>http://freenet.buffalo.edu/~bz176
>
Hi there,
You can try RTRIM(char variable) to return VARCHAR2 data type. RTRIM will remove the trailing blanks in Char variable.
Good Luck
N.Prabhakar Received on Sun Dec 01 1996 - 00:00:00 CET