Want to use "null" value in parameter drop down box

<i><b>Originally posted by : Paula Hamilton (paula.hamilton@verizon.com)</b></i><br /><br />I want to use a "null" value in my parameter drop down box that will be used in a select statement. When a user chooses a null value, I want all rows for that field to show up. <br /><br />For example:<br /><br />SELECT * FROM Table WHERE (Field = '::Field::')<br /><br />Please help!

<i><b>Originally posted by : notimportant (jhunt@alagreen.com)</b></i><br />If you want all of the rows in the field to show then leave the WHERE CLAUSE out of the QUERY<br /><br />from:<br />SELECT * FROM Table WHERE (Field = '::Field::')<br />to:<br />SELECT Field FROM Table<br /><br /><br /><br />------------<br />Paula Hamilton at 4/20/2001 2:44:48 PM<br /><br /><br />I want to use a "null" value in my parameter drop down box that will be used in a select statement. When a user chooses a null value, I want all rows for that field to show up. <br /><br />For example:<br /><br />SELECT * FROM Table WHERE (Field = '::Field::')<br /><br />Please help!