SQL syntax

Any help on the correct syntax of executing the following SQL statement:

INSERT INTO tbGNFilter(FilterName, ViewName, Script) VALUES('Filter2', 'vwAccList', ' WHERE Code = \'123\' ')

I think that this should be correct, but apparently it isn't....any help??
LVL 3
mte01Asked:
Who is Participating?
 
rafranciscoCommented:
It should be like this:

INSERT INTO tbGNFilter(FilterName, ViewName, Script) VALUES('Filter2', 'vwAccList', ' WHERE Code = ''123'' ')
0
 
mte01Author Commented:
Excellant!!...It worked!..thanks...
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.