detect end of CAPS text in string

[GeertL]

Hi,

Maybe a simple question...

I have a column in my database which looks like this : FAMILYNAME prename
also FAMILY NAME pre name ... etc is possible.

I need to split up the familyname (which is in Ucase) and the surname which always is in lcase.

Anyone has a solution?

tnx in advance

[GeertL]

found something that works :

For Each c In sName
If Char.IsUpper(c) Then
sFname = sFname & c
Else
sSurname = sSurname & c
End If
Next