Seperating Name field

On a side note, you would have an easier time if you stored the first, middle and last names in separate fields. That is assuming you have control over the db. If not, you could use the technique mentioned to treat the values as a space delimited list. The technique won't be perfect. But the code should at least handle special cases like this

John Edward Morgan III (the name contains 4 parts)
J.P. Adams (first and middle are not separated by space)
Michael Russell (no middle name or initial)

ie. Every name may not have exactly 3 parts delimited by a space

Do a CFSET foo = ValueList(myQueryName.myNameColumn)>
You now have a comma-delimited list of full names. Then do
<CFSET bar = Find(" ", foo)>
bar now contains the the position of the first space in the first element in your name list. Everything to the left of bar is the first name; everything to the right of bar + 1is the (middle initial) last name. Delete the first element in your name list and repeat this process until bar is zero.

See concept code below.

Hi,

Use the ListGetAt() function.