Hi Larry, thanks for responding

I have tried all of the following. With no results.

'date_items' is a variable that holds all the users date selections. It is in Character format

AND convert(varchar(10), ord_req.ord_dt, 101) LIKE &date_items
AND convert(varchar(10), ord_req.ord_dt, 101) LIKE ?date_items
AND convert(varchar(10), ord_req.ord_dt, 101) IN ( &date_items )
AND convert(varchar(10), ord_req.ord_dt, 101) IN ( ?date_items )

I even tried to hard code a date, still no result
AND convert(varchar(10), ord_req.ord_dt, 101) LIKE '01/03/2000'
AND convert(varchar(10), ord_req.ord_dt, 101) IN ( '01/03/2000' )

What am I still not understanding???

Mike