SQL functions in where?

[Tim Davis]

Hi,

    Is it possible to use an SQL function in a Where clause?
Example: SELECT field1 FROM mytable WHERE left(field1, 2) = 'ab'
Or, is there alternate approach to this (besides Regex)?

Thanks,
Tim Davis