Use of ' in a query.

Bahatmut

Active member
Joined
Jun 14, 2005
Messages
29
Location
NY
Programming Experience
Beginner
Ok, made a program, ti works fine 90 percent of the time. It is designed to INSERT NEW RECORDS into a database that holds video tape data. Here is the problem, some of the video titles contain an apostrophe, or single quote (') The same char that is used int eh SQL INSERT query to denote start and end of strings. I have tried searchign the MSDN and not found any work around. Is there any way to use a ' mark within a string value for a SQL INSERT query?
 
Back
Top