I have imported a name list (about 200 000 names ) from an Excel DFB-file. For some reason the the first and last name are put together without space like 'AndersSvensson'.
They are all like that.
I can't figure out how to split the name into First name and Last name or insert a space.
Can it be done through SQL?
Looking forward to the reply.
They are all like that.
I can't figure out how to split the name into First name and Last name or insert a space.
Can it be done through SQL?
Looking forward to the reply.