Thanks Michael, Peso and everyone! My question is now resolved

regards,

Abhishek

Many thanks Michael for taking pains in solving my problem! I tried solution on my data but I find some incorrect records. For example add a record for 7-May-2008 10:30...

Dear All,

Thank you very much for your expert views on my problem.

As I develop ERP products that target multiple countries I wanted a generic solution to my problem. Here is...

Thanks,

I am already doing it. Still my queries fail in because they are written in case insensitive way. I would like to know how other people are doing it. One...