Hey Guys. I have a field called name in the contact.xls file that contains the fullname. How do i separate the name into first , middle and last in an sql statement? here are some different examples. They all seem to have the same format which is a firstname space middle intitial "." then lastname
Richard M.Rewser Jr.
Jon P.Gaynor II