I just inheritted a badly setup database, where paymDate is varchar(20), but its contents is formatted as m/d/yyyy
My question is, in this case, how can I SELECT all records between 6/1/2011 and 6/30/2011?
When i do the following, i also get June 2010 data.
/****** Script for SelectTopNRows command from SSMS ******/
SELECT TOP 1000 [id]
WHERE [paymentDate] >= '7/1/2011'
AND [paymentDate] <= '7/31/2011'
ORDER BY id