Re: splitting names from db
First suggestion would be to normalize your database. Second would be to use SubString() and IndexOf Methods to split up the string on the last space.
Re: splitting names from db
i can't really see how you can do that with those functions ? :s
can u give me an example pls?
Tnx
Re: splitting names from db
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim Name As String = "Van Hagen John"
Dim First As String = Name.Substring(Name.LastIndexOf(" "))
Dim Last As String = Name.Substring(0, Name.LastIndexOf(" "))
MsgBox(First & "-" & Last)
End Sub