SQL Server Insert Query - single quote problem
Posted on 2009-04-09
Please review the following lines and tell me your suggestions
INSERT INTO tbl_test(fld_Id,fld_name,fld_interests)
column values described as below
fld_id - 1
fld_name - Andy
fld_interests - 'A1','A3','A4'
when executing this query im facing error says
"no of columns and values not matched"
i need to insert single quote separated values into a single column
how can i do this
It is possible by using escape sequence, but i need to add and remove single quotes dynamically
is there any other suggestions