Eric,
Sorry but I really didn't understand your response.
But, an experienced VB/SQL person just informed me that you CANNOT use a user-defined function in a SQL statement ... when Executed via ADO and the underlying drivers. Having used UDFs before in VFP & Access, this comes as a surprise.
Steve H