SQL QUERY - HELLLLLLLLP!

[apexinternet]

if I have a list say


George W. Bush
Earl Jenkins
Jennifer Anniston
John William Johnson Jr.
Chris Norris

how do I just pull first and last names from this?

I want it to return

firstname Lastname
George Bush
Earl Jenkins
Jennifer Anniston
John Johnson Jr. or Johnson
Chris Norris

Please help me!

Chris

God Is AWESOME!

 

[GGleason]

Chris,

You can do this a couple of ways:

1. Add fields for the first, middle, and last name, and sequence. Then you can join the fields how you want in a query (this is how I would do it).

2. Create a function where the name list is passed to the function. Within the function, you test conditions to see how many spaces are in the string. The function then returns the name based on those conditions. The function is then referenced in your query.

hth,
GGleason

 

[apexinternet]

I didnt even get your post before I fixed it.. I used the second way...thanks.

Chris

GOD IS FAITHFUL!

 

[GGleason]

Amen.