select statement

Hey,

I understand that sql server want single qoutes surrounding values when using select statement. What happens when the value contains a single qoute in it? Do I use double qoutes?

Thanks,

You use two single quotes.