Crystal Reports Name Structure problem

Message

My ODBC table has one field for name.
The structure is lastname, firstname middleintital.
There is not always a middleinitial.
The code I'm using (follows) only gives me the middleinitial:

local StringVar Array Names1:= 
Split({OptimizeIt.OrderRepName}, " ");
If UBound(Names1)=3 Then ProperCase(Names1[3]) Else " "

Changing it to the following only gives me the firstname:

local StringVar Array Names1:= 
Split({OptimizeIt.OrderRepName}, " ");
If UBound(Names1)=2 Then ProperCase(Names1[2]) Else " "

Changing it to the following gives me nothing:
(You'd think it would give me the lastname):

local StringVar Array Names1:= 
Split({OptimizeIt.OrderRepName}, " ");
If UBound(Names1)=1 Then ProperCase(Names1[1]) Else " "

Can someone help me put this all together so I get firstname middleinitial lastname (and no comma)?
Thanks.

Edited by Krazy Kasper - 27 Jan 2009 at 5:48am