Ask the Expert

Characters in syntax

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?

Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: