hi

i need help finding a solution for my problem...

i reading names from a database field and i want to split them in 2 colums,

For Each DR In DT.Rows
sString = DR.Item("Customer")
Dim Name() As String = sString.Split(" ")
MsgBox(Name(0))
Next

works fine for names like smith john, with 2 words but suppose a name has 3 words like Van hagen John, you have 2 spaces. is their a way to see the last space so you can filter out the prename ?

tnx in advance