Storing appostrophe's in SQL

From: Jeff (anonymous_at_discussions.microsoft.com)
Date: 08/05/04 

Date: Thu, 5 Aug 2004 14:17:03 -0700

I have a text box that allows the user to type in free
form text. I want to save it to a SQLServer database
table. If the user types in <Here's Johnny!>, I can insert
it into SQLServer by inserting the text string <Here''s
Johnny!>

My question: is there a function that does this, or do I
process the text string before I insert it to double all
the appostrophe's?

Thanks!

Relevant Pages