I'm not sure if charindex supports wildcard....

--Assumption 1 - FirstName and LastName are both Not Null

--Assumption 2 - There are only 2 capital letters and they are first character of first name and first character of last name

declare @fullname varchar(200)

declare @myLen int

Declare @start int

Declare @pos int

Declare @firstName varchar(200)

declare @lastName varchar(200)

@fullname='RobertJain'

@l=len(@myString)

@start=2

While (@start<=@l)

BEGIN

@C=substring( @fullname ,@start,1)

if ascii(@c) between 65 and 90

Begin

@pos=@start

BREAK

end

end

@FirstName=left( @fullname , @Pos-1)

@LastName=right( @fullname , @l-@pos-1)