Good point. It's about 4000 records that would call this function.

The data is pretty dirty. I'm pulling from a mainframe and retrieving First Name, Middle Name and Last Name. 19 out 20 times, First and Middle Name are all crammed into Last Name. But not always. Since the mainframe requires an entry on First and Middle Name, the user (not us) will just type crap into the fields.

In any event, let me experiment with doing it directly in the SELECT Statement.

Thanks guys - you guys are great.