Here is a procedure for SQL Server which can be created in a module and called from a query using InitCap([fieldname])....thanks to Paul