Prepared Statement Where Value IS Null Or Value = :x

Hello,

I have a table which contains some nullable columns. I want to write a
single query, which can be prepared (ie. prepared statement), that can
handle null or non-null values for the where clause. Is this possible
in a standard-conforming manner?

The simple for of the query is this:

SELECT * FROM <table> WHERE <column> = <value>

But when the value to be matched on is NULL, the syntax of the query
must change to be:

SELECT * FROM <table> WHERE <column> IS <value>

In the second case <value> is NULL.

I know one option might be to change the ANSI NULL handling option,
but I am loathe to do this (I have five RDBMS's to support, not just
MSSSQL).

I thought I might have been able to cheat using an IN clause to make
the SQL consistent, but no luck.

Thanks

Kevin