i have to use like keyword in my query in ASP
while using it in analyzer i am getting the result but when i am using it on page i m not getting the result of a simple.
Qery is :
select checktime from checkinout where checktime like '*"&any_dt&"*'
any_dt is a date in mm/dd/yyyy format.
this is working fine in analyzer but not on ASP Page.
why is it happening i dont know.
Please help me out as soon as possible.
thanx a lot in advance.