seperate name by space

G

GEORGIA

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!
 
O

Ofer

Try this

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

GEORGIA

WORKS PERFECTLY!! Thank you!

Ofer said:
Try this

Select Left(FieldName,Instr(FieldName," ") -1) As FirstName,
Mid(FieldName,Instr(FieldName," ") +1) As LastName From TableName
Click to expand...
 
Top