Hi Larry, I tried

AND charindex(convert(varchar(10), ord_req.ord_dt, 101), '01/03/2000') > 0

This also does not seem to work. I forgot to mention that I am on ORACLE 7.3 not SQL Server. Perhaps this might be the problem? If so, sorry about that. I was under the inpression that the syntax was the same.

Mike