Special Character "-" in SQL

Results 1 to 2 of 2

Thread: Special Character "-" in SQL

  1. #1
    Join Date
    Dec 1969

    Default Special Character "-" in SQL

    I have an access Database with fields containing the "-" character.<BR><BR>When running the SQL, I do not get the expected result.<BR><BR>I read how to handle the "&#039;" (replace it with "&#039;&#039;") Is there a similar way with the "-" Character?<BR><BR>Thanks<BR>Vinci

  2. #2
    Join Date
    Dec 1969

    Default Avoid Special Characters

    select [a-b] from t<BR><BR>works but my advice is to rename the columns.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts