Need help splitting string in query

[fenerfan]

Hey people,

This should be any easy one to solve:

I need to split a field in my query into two separate fields, e.g fullname into a first and last name, so "John Smith" will appear in two columns, "John" and "Smith".

Thanks in advance.

 

[namliam]

Lookup the functions Left, Mid, Right and Instr in the help and you should be good to go.

 

[Guus2005]

Or you could use my recursive getpart functionEnjoy!

 

[gemma-the-husky]

you ought to thing about storing this in your databaseas two separate fields.

splitting the string is all very well, but what do you do with

John Smith
John William Smith
Mr John Smith

presumable you want to take the last word as the surname, but can you be sure