I read on the internet that on SQL you can use "--" or "#" for Documenting - to ignore everything that comes after that mark (like ' in VB or // in C). Yeah, cool, but its not working. I opened up an IIS server and built a simple .asp file that contain sql commands and among them this line :

R.Open "Select * from [Test]"

Yup, the asp is worknig. but when i change this line to one of this lines :

R.Open "Select * from [Test]#BLA"
R.Open "Select * from [Test]--BLA"

Its not working.
I tried with spaces etc. Still not working
Why? Any solution?