One of our developers wants to put the following into his database...

St James's

...including the '.

Obviously insert into tab values ('St James's') doesn't work and not being an expert in these kind of things I'm a bit stumped. Any clues?