Showing results for 
Search instead for 
Do you mean 

How to Embed Double Quotes in a Literal for SQL Server.

by Anonymous on ‎02-15-2016 09:57 AM - edited on ‎04-06-2016 01:16 PM by Moderator (2,944 Views)


How do you embed double quotes in a literal when using SQL Server?


If you enclose the whole string in double quotes instead of single ticks, you have to double double quote double quotes. For example:


update isistypes set sfviewname = "Tim's value=""some value""" where id = 1;


Would yield a value of:  Tim's value="some value"  to the column.