I am searching large databases of telephone records. The databases combine domestic and UK calls. I want to create two databases. One database will contain all of the calls to the UK and One database will contain all of the calls to the US. My query for UK calls went perfectly. However, when I query for non-UK calls, I get error messages. What do I do about the syntax?
Like most computer languages, SQL is picky about the characters used for syntax. Sometimes, "smart quotes" are inserted by some word processors. Stick to straight quotes (') around strings and backticks (`) around identifiers (table and column names).
This was first published in August 2006