You can use the common math comparison operators to compare numbers or dates. In many cases, you also need to cast column data to an appropriate datatype for the comparison to be successful.

See also Literal Values in Conditions or Expressions for more information.