Calling UDFs from ADO SQL

[jmcswain]

Can you call a UDF (in VB or inside a module in the Access Database) inside a SQL statement in ADO?

For example:

Dim rst As Recordset
rst.Open "SELECT GetRegion(tblMain.Zip) FROM tblMain;"

Public Function GetRegion(pvarZip as Variant) As Variant
    ' blah blah blah
End Function