apostrophe's in an update statement

I'm too lazy to look it up, but how would you format a string that contains an appostophe or single quote in a SQL statement? For example:

I want to update the city_name column of one of my tables with the following value: COEUR D'LENE. How would I enclose the single quote/apostrophe? Thanks in advance.

'' (If you're too lazy to look it up, I'm too lazy to give you a full explanation)