The following diagram shows the SQL statement syntax for multiple data types.
NUMERIC DATA TYPE:
CHAR/BINARY DATA TYPE:
DATE/TIME DATA TYPE: