Hello,
I've got a stored procedure written that will send a query to a Finger server and return information about a person. Currently, I get the person's name like this:
Smith Joe R.
I would like to reformat this within the sp to read:
Joe R. Smith
or even break the name down into three separate fields. Not all people will have a middle initial. I'm lost without my VB Split function!!! Any ideas?
TIA
Brian McCool