sql select with apostrophe in string code example

Example: sql select with apostrohpe

Select * from tblStudents where name like 'Daniel O''Neal'