Substring Function

[Mark]

I am trying to exact and compare a substring using an
access query. Access says 'Undefined function substring'

I use substring in SQL. What is the deal?

 

[Allen Browne]

Instr() might do what you need.

 

[Duane Hookom]

Try Mid()