how do you change a datatype in a query

[Angela]

I would like to recreate the following Oracle SQL statement in Access
To_number(a.field) = (b.field)

 

[Duane Hookom]

Maybe
Val(a.field) = (b.field)