SQL Server 2000 + inserting quoted strings

[charles]

Hello,

I am trying to insert quoted strings into a database table, however, I cannot remember how to do so. For instance, I am trying to insert the following values into a SQL table:
My Friend's
"Happy Birthday"
exactly as they are listed. How can I do that in a SQL insert statement?

regards
charles -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[justchill]

Hi

Original - SQL Code
print 'My Friend''s'
print '"Happy Birthday"'

-- or

set quoted_identifier off
print "My Friend's"

print 'My Friend''s'print '"Happy Birthday"' -- or SET quoted_identifier offprint "My Friend's" -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --