I have a table that has the following columns:

nlUnit int
tDate nvarchar(10)
ndAmount float

I want to retrieve a recordset that converts the tDate to a datetime. I am using the following to do so:

SELECT nlUnit, CONVERT(datetime, tDate) AS dDate,ndAmount

My issue is that I want to also use a where statement like

WHERE (ndAmount >= 50.00) and (dTradingDate BETWEEN '4/1/03' AND '4/15/03')

This is not working. I am retrieving my recordsetand then applying a date filter to it.

Does anyone know the correct syntax for the above. If not, is there a better work-around?

Thanks in advance.