Christianto Tjahyadi schrieb:

> I expect, when I do a SELECT with option WHERE COLUMN2 LIKE '%', all of rows
> will be displayed, including the rows with COLUMN2 is null. But when I do a
> SELECT with option WHERE COLUMN2 LIKE 'A%", only rows with the first
> character is 'A' will be displayed.

You expect wrong.

NULL is NULL and is NOT an empty string, it's unknown.

Change your design of saving values.

If you exepct empty strings to be treated as empty strings, save empty
strings and not null.


Luc.