in microsoft sql server 2012 how to execute literal select statement with apotrophe code example

Example: sql select with apostrohpe

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