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