apostrophe in query sql code example

Example: sql select with apostrohpe

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