Posted on 2014-11-19
I have a MS SQL table that holds data from several memo fields. The data in the memo fields can contain apostrophes and double quotes. How can I make it so that SQL accepts these?
Here is an example of hard coded values as an example:
insert into MDP_data (psc#,priority,fy,status_code,justification,staff_comments)
'Deferral of partial funding is recommended. Planning was approved in FY13 and partial funding was approved in FY14 and FY15. See worksheet for approved scope and funding details.',
'10/29 Comments: The LEA will bid in feb and start construction in April 2015. DDs rec'd by DGS. CDs are underway. There maybe a delay in demolition. There are several large alternates for this project. MEMA issues are all worked out. They would like to receive full funding for this project.')