Null values

[VictoryHighway]

Hello,
I need to generate a SQL query on a table that I need to have a Like "*" for each field. However, this doesn't work if the field is null. Is there a way around this?

Thanks in advance,

Geoffrey

 

[Golom]

(fld LIKE '*' OR fld IS NULL)

but note that LIKE '*' matches everything but NULL so the above is equivalent to "all values" which is what you would get with no selection criteria at all.

 

[VictoryHighway]

Golom,
Basically I just wanted that to be a "placeholder", so that that could be easily replaced by some VBA code if necessary. That seems to work.

Thanks,
Geoffrey