Hi,

> When we use LIKE '%', adding OR COLUMN2 IS NULL will solve the problem.

But

> when we use LIKE 'A%', the rows with null columns will be displayed too. I
> will put '%' or 'A%' in a bind variable.

So, what do you expect? LIKE is a comparison
operator, while IS NULL isn't.

No column value ('A' or whatever) will ever equal
NULL.

NULL = NULL results into False.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com