PROBLEM WITH LIKE OPERATOR IN SELECT WHERE CLAUSE
From: shamai markel <shamaim_at_amdocs.com>
Date: Wed, 23 May 2001 13:52:26 +0200
Message-ID: <990615107.590810_at_sointnews.amdocs.com>
Date: Wed, 23 May 2001 13:52:26 +0200
Message-ID: <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 Wed May 23 2001 - 13:52:26 CEST