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