i have table report contains colume report_date having datatype nvarchar..
but now i want to get report before specific date..so how i can get that report correctly..
ex. i want to get report <'7/8/2009 10:10:50 AM'
how i can write query for that...