1DECLARE @my_table TABLE (
2 [value] VARCHAR(200)
3)
4
5INSERT INTO @my_table VALUES ('hi, my name''s tim.')
6
7SELECT * FROM @my_table
1/*adding single quote into the string in SQL*/
2on P.SupplierID=S.SupplierID
3where S.CompanyName in
4('Tokyo Traders','Exotic Liquids','Grandma Kelly''s Homestead')
5