Syntax Error when connecting to SQL server

  • Thread starter Thread starter Brave
  • Start date Start date
B

Brave

I am connecting to an SQL database and one of the fields is named
"Case#".

I am getting syntax errors trying to connect, and am pretty sure it is
because of the special character in the name (#).

Is there anything I can do to get around this without having them
change the name andremove the special character?

This is the line, I think the problem exists:

fp_sQry="SELECT * FROM ""Returns Info"" WHERE (Case# = ::Case#::)"
 
Back
Top