Pound Sign in SQL statement?

hello there,

On my database I have a '#' sign in the field name. How can I pass an SQL statement to an adodc object with a pound sign in the field name.

Here is my code
Adodc1.RecordSource = "SELECT DISTINCT Route# FROM dbo_Master"
Adodc1.Refresh

I have also tried:
Adodc1.RecordSource = "SELECT DISTINCT Route'#'....

as well as:
Adodc1.RecordSource = "SELECT DISTINCT Route" & "#" ...

if you have an answer i would really appreciate it. Thank you.

-Jason

Brackets... anytime there's a space or a non-alphanumeric in a field/table name, use brackets...

Code:

---

SELECT DISTINCT [Route#] FROM dbo_Master

---

Thanks alot, worked like a charm.

Glad to hear it. Could you put RESOLVED into the thread subject (edit the first post, then change the subject line) so that someone else who has the same prob knows they can find a solution here.