Re: PROBLEM WITH LIKE OPERATOR IN SELECT WHERE CLAUSE

Try

SELECT * FROM table WHERE RTRIM(field, ' ') LIKE 'A%C'

Best!

Randall

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 Fri May 25 2001 - 03:57:48 CEST