>> At what point do I work with the appastrophe to keep it from dropping? > > Only when doing INSERTs and UPDATEs and also when specifying a search string in a SELECT e.g. where lastname = 'O''Toole' ;o)