Re: How to join two tables by CHAR and VARCHAR2 fields in Browser?
From: Terry Dykstra [TeamPS] <no_spam_tdykstra_at_cfol.ab.ca>
Date: Tue, 20 Oct 1998 17:07:28 -0600
Message-ID: <362d1726.0_at_news.cadvision.com>
Date: Tue, 20 Oct 1998 17:07:28 -0600
Message-ID: <362d1726.0_at_news.cadvision.com>
You can RTRIM(char_col).
-- Terry Dykstra [TeamPS] Canadian Forest Oil Ltd. suisum_at_freenet.edmonton.ab.ca wrote in message <70irop$a3$1_at_news.sas.ab.ca>...Received on Wed Oct 21 1998 - 01:07:28 CEST
>Hi:
>
>Can anyone share experience how to join 2 tables which one joint key is
>CHAR, another is VARCHAR2. I have problem to retrieve records properly as
>the CHAR fields contain trailing blanks.
>
>--
>Best regards,