SQL Select of a name with ' in text

[Justin Kerby]

This may seem easy for some but how do you sql select from a table a name with ' included. e.g. select everyone with the surname O'Brian

At the moment I am using Select * From Employees where [surname] = " xsurname " wher xsurname has the name.

[Chris]

SELECT * FROM Employees WHERE [SurName] = 'O''Brian'

OR

DECLARE @name varchar(20)
SET @Name = 'O''Brian'
SELECT @NAme
SELECT * FROM Employees WHERE [SurName] = @Name

------------
Justin Kerby at 9/22/00 7:14:16 AM

This may seem easy for some but how do you sql select from a table a name with ' included. e.g. select everyone with the surname O'Brian

At the moment I am using Select * From Employees where [surname] = " xsurname " wher xsurname has the name.