seperate name by space

[Guest]

Hi,
I have a column with name like this: Jane Doe.
I would like to seperate this by space so that i'll have two columns: First
name: Jane and LastName: Doe. How would i do this in query??

Thank you!

 

[Guest]

Try this

Select Left(FieldName,Instr(FieldName," ") -1) As FirstName,
Mid(FieldName,Instr(FieldName," ") +1) As LastName From TableName

 

[Joseph Meehan]

Hi,
I have a column with name like this: Jane Doe.
I would like to seperate this by space so that i'll have two columns:
First name: Jane and LastName: Doe. How would i do this in query??

Thank you!

More information please.

How is the name stored now (in the table)? Normally we recommend having
a First name field and a Last name field then you can put them together
easily or make two columns out of the data.

How consistent is the data? Do any names include middle initials etc?

Do you want to display the data this way or print it as in a report??

 

[Guest]

WORKS PERFECTLY!! Thank you!

Try this

Select Left(FieldName,Instr(FieldName," ") -1) As FirstName,
Mid(FieldName,Instr(FieldName," ") +1) As LastName From TableName