Aug 18, 2005 #1 Horsegag9 Technical User Jan 25, 2005 9 0 0 AU Hello All, What is the syntax for including a single quote or ' in my query? I know you have to wrap it in something, but I can't remember what it is. Thanks in Advance Horse
Hello All, What is the syntax for including a single quote or ' in my query? I know you have to wrap it in something, but I can't remember what it is. Thanks in Advance Horse
Aug 18, 2005 #2 DotNetGnat Programmer Mar 10, 2005 5,548 0 0 IN Replace(yourfield,"'","''") -DNG Upvote 0 Downvote
Aug 18, 2005 #3 SQLBill MIS May 29, 2001 7,777 0 0 US Here's an example.... Code: INSERT myTable (LastName) VALUES ('O''Donnell') -SQLBill Posting advice: FAQ481-4875 Upvote 0 Downvote
Here's an example.... Code: INSERT myTable (LastName) VALUES ('O''Donnell') -SQLBill Posting advice: FAQ481-4875