Access Db to SQL server

[Albert3162]

Hi there,
I have EMP table in Access DB. and in column name I've got data like: John Smith J.
How convert this data to SQL sever table with ccolumn:
FirstName, LastName, Midle?

Thaks.
Albert

 

[SQLSister]

Well now that depends on just how good your data is. YOu have to consider things like last names with spaces, two word first names (Mary Jo), things like Jr. or III at the end of the name.

But basically you can use charindex or patindex to find the spaces. Then use the location of the space to help slpit off the proper word using the left right and substring fucntions. There are some code examples here if you search.

Questions about posting. See faq183-874