Alter function func_TenantID
(@FirstName varchar(20), 
@LastName varchar(30),
@increment char(2))
Returns char(10)

As
Begin
Declare @firstletter  char(1)
Declare @lastSeven varchar(7)
Declare @tenantID  Char(10)

Select @firstletter=substring(@firstName, 1,1)

if len(@Lastname) < 7
begin
Select @lastSeven=substring(@lastName,1,len(@lastname))
end

Else
begin
Select @lastSeven=substring(@lastName,1,7)
end

Select @TenantID=@firstletter + @LastSeven + @increment

return Upper(@tenantID)
end

--Select dbo.func_tenantID('Steve','Conger','01')