Parsing for upper case letters ( isuppercase() ?)

[aclayborne]

I need to convert "DoeJohn" to "Doe John"
Is there a function in vb the will detect upper case letters? Or do I have to parse thru the string and verify each characters ascii value?

 

[BiggerBrother]

for i=1 to len(mystring)
if mid(mystring,i,1)=ucase(mystring,i,1) then
' character is capital
else
' character is lower case
end if
next i

BB

 

[aclayborne]

Thanks I changed ucase(mystring,i,1) to
ucase(mid(mystring,i,1))

Thanks for the help.