all values?

[jacquesy]

I am developing a fairly long quesy string using input from a number of select lists in a form.

In these lists I have a "Do not specify option" followed by other values.

Is there a way of using the "where" statement but still selecting all records?

e.g.

select * from model where ModelName = all of the ModelNames records

I'm sure there would be way of doing this?

Thanks.😃

[zhabala]

Easy way is
WHERE 1=1
or
WHERE true
in case that the database supports it