| Subject | Re: [firebird-support] Null and LIKE Clause |
|---|---|
| Author | Dimitry Sibiryakov |
| Post date | 2004-04-28T05:45:34Z |
On 27 Apr 2004 at 18:56, Christianto Tjahyadi wrote:
1. Alter column COLUMN2 to have default '';
2. UPDATE X SET COLUMN2='' WHERE COLUMN2 IS NULL;
SY, Dimitry Sibiryakov.
>When we use LIKE '%', adding OR COLUMN2 IS NULL will solve the problem. ButDo this:
>when we use LIKE 'A%', the rows with null columns will be displayed too. I
>will put '%' or 'A%' in a bind variable.
1. Alter column COLUMN2 to have default '';
2. UPDATE X SET COLUMN2='' WHERE COLUMN2 IS NULL;
SY, Dimitry Sibiryakov.