Trouble With Strings

Hi,
I have been having a few problems with strings (varchar)s.
How can I insert a quote ' character in a string?
The following, needless to say does not work:

    INSERT INTO table (string) VALUES ('colin's');

Also, are there any other characters that need special attention in order to
put them into the table?
And how can I handle them?
Thanks,
Colin