Getting Crazy Error!

I keep getting this stupid error, if
any of you have time to kill and could look at this I would really appreciate
it.
This checks for a login in the
database and if it already exists it makes it unique.




In the error message, €˜ssewell504€™
was the value returned after the proc ran, the last 3 digits will be different
each time it€™s ran.

Thanks guys and take
care!Here's the error:

"Syntax error converting the varchar value 'ssewell504' to a column of datatype int"


ALTER proc
[dbo].[spx_CONS_CheckLoginUnique]

(
@SourceLogin varchar(25) = 'ssewell',
@TargetLogin varchar(25) = 'ssewell'
)
as
begin
declare @ReturnedValue int
declare @AlreadyInUse int
declare @AppendedValue varchar(3)
declare @Range int

set @Range = 999
set @AlreadyInUse = 1 -- set flag


--if target login and source login are
the same...we need to change target
login
if @SourceLogin =
@TargetLogin
begin
while @AlreadyInUse = 1 -- this stays eq to 1 until target login
is unique in DB
begin
Set @ReturnedValue = CONVERT(int, (@Range+1)*Rand()) -- get random
num
Set @AppendedValue = CAST(@ReturnedValue as varchar(3)) -- cast value to
varchar
set @TargetLogin =
@TargetLogin + @AppendedValue --
append to target login
--if by chance this login is already in
there(taken), keep going until it's
not
if EXISTS(select Login_Name from dbo.SECR_Login where Login_Name =
@TargetLogin)

begin

set @AlreadyInUse = 1
--set flag to keep
looping

end
else

begin

set
@AlreadyInUse = 0 --set flag to exit out of loop, our login is now
unique

end
end
end

return
@TargetLogin
end