Inserting a string with an Apostrophe

From: CB (anonymous_at_discussions.microsoft.com)
Date: 04/29/04 

Date: Thu, 29 Apr 2004 13:16:04 -0700

I would like to insert a value with an apostrophe into a character field. I keep on getting "commande text not set for command object". Is there a character that I can put before and after the string to show that the system should take the exact value and not look at the characters as an indicator?
EX: Insert into NAME (LASTNAME) Values ('D'Mario')