how to deal with ' in sql query code example Example: sql select with apostrohpe Select * from tblStudents where name like 'Daniel O''Neal'