INSERT INTO (SQL)

Hi, I need to insert a text field
let say (Bird's Eye) .
Ah ha ! See the problem .
SQL Insert requires me to put in Quotes (') before and after a string . For my case , a additional quote is found
and this generate an error to me .
For those who know how to to solve this problem please
help me .Okay . Thanks
LVL 2
seahpcAsked:
Who is Participating?
 
yowkeeConnect With a Mentor Commented:
  Use double quote: "Bird's Eye", or if you are using RDO in
VB to insert, use single quote 'Bird''s Eye' in the insert SQL string.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.