Обсуждение: Retrieving a ' in an SQL statement?

Hi,
    I need to know if there is any way to pull a record into a recordset which
contains a hyphen( ' ) when using an SQL statement.  I am using sql statements
to query an Access 2000 database.  ANy help would be greatly appreciated.