Re: converting chars to varchar2's. Please hel

From: Mani Maran <mmaran01_at_csd.eds.com>
Date: 1995/08/17
Message-ID: <4103qu$mif_at_maverick.tad.eds.com>#1/1

If you want to compare a varchar2 and char data type, say rtrim(char) = varchar2 data type . What is happening when you say char is , there is a padding occurs on the right side. So remove the white spaces with rtrim to make it equal to varchar2.

---
Your_Name <your_id_at_csd.eds.com>                  EDS consultant
Voice: 214-828-7572 Fax: 841-6886                999 Haskel
Commercial Services Division, Southland Account  Dallas, Texas 75... USA
"Opinions expressed herein are not necessarily supported by my employer."

Received on Thu Aug 17 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Bill Lanphear: "Wanted: Technology Director for Internet Information Service"
Previous message: Vincent Pommier (Toulouse): "Re: Where can I get an ODBC driver for Oracle??"
In reply to: DINESH PUNJABI: "converting chars to varchar2's. Please help"
Next in thread: Marty Bronstein: "Re: Filtering Records in SQL Forms 3.0"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message