How indicate characters in 'where' statement ?

Answer 1

If you are referring to varchar date, you have to write for ex. WHERE city='New York';

Answer 2

By enclosing characters in single quotes e.g 'Student names'