Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> question about string matching with trailing blanks

question about string matching with trailing blanks

From: Gary Beckler <gbeckler_at_easystreet.com>
Date: Sat, 8 Sep 2001 08:08:48 -0700
Message-ID: <tpkcv1juhqk2e@corp.supernews.com>


In the code below how does Oracle match on field with trailing spaces?

create table a (
 dept char(6) );

 insert into a values ('LABOR ');

 select * from a where dept IN 'LABOR';

Does "dept" match "LABOR"? Is the "rtrim" function necessary? Received on Sat Sep 08 2001 - 10:08:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US