At 07:27 PM 27/04/2004 +0700, you wrote:

>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.

Wrong expectation. LIKE works on values, not states. (c.f. IS NULL which
works on states, not values).

NULL can't be LIKE anything. It's not even LIKE NULL.

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

That's good - it works, then. :-)

/heLen