Exclamation mark in field

I've got a field in one of my tables (sql server db) called Department. One of the entries in this field is 'Director's Office'... how can I write a query that selects all the entries where the Department= 'Director's Office'... the exclamation mark is causing me problems...try Department= 'Director''s Office'|||Thanks again Paul!