Re: PROBLEM WITH LIKE OPERATOR IN SELECT WHERE CLAUSE

Don't use Char fields use varchar2 fields. Jim
"shamai markel" <shamaim_at_amdocs.com> wrote in message news:990615107.590810_at_sointnews.amdocs.com...
> Hi,
> 1. In difference from '=' operator, LIKE opearator does not ignore
 trailing
> blanks in CHAR type fields.
> 2. This means that for a CHAR(5) field containing 'ABC ', the following
> SELECT statement will return no lines :
> SELECT * FROM table WHERE field LIKE 'A%C', whereas following SELECT
> statement will return the line :
> SELECT * FROM table WHERE field = 'ABC'.
> 3. Does anyone have a bypass to this problem that doesn't require to pad
> blanks to the searched string and that doesn't inluence performance ?
> thanks very much
> shamai
>
>
Received on Thu May 24 2001 - 15:26:14 CEST