I am converting an Access 2003 app to an ADP/SQL Server app.  The
application was created by someone else.  There are several forms,
queries and reports that call a VBA function that contatenates a
person's name in a presentable format (it deals with whether they have
a prefix, suffix, etc. )using a CASE SELECT statement. This function
works fine after the upsize in forms, but does not work correctly in
the udfs or sprocs. Can a function be called from a udf or sproc or
should i rewrite it another way and what would the best way be? Thanks
for any help!

JEM