How do I send a hyphen in a SQL statement?

[SirPaladin]

I need to use SQL to perform a lookup, but I don't know how to format the search string if it includes a hyphen. For example, looking up the name "O'Neill" currently produces an error due to the hyphen. What's the work-around?

 

[RickSpr]

I assume you mean the apostrophe "'" (a hyphen is a "-&quot.

For each apostrophe that is part of the quoted data, simply double it. Thus, your SQL statement might be:

  SELECT * FROM MyTable WHERE LastName = 'O''Neill';

Rick Sprague