sql if else

CREATE procedure dpt
@ename varchar(50)            -- enter users value
as
BEGIN
declare @name varchar(50),  -- copy user value into variable       
@ifcheck varchar(50),        -- to get second charachter from users string
@no int,                    -- to check character isnumeric by using function ISNUMERIC
@notpresent varchar(50),    -- users value does not exists
@count int                  -- to count the records
set @ifcheck = (select substring(@ename,2,1))
set @no = ISNUMERIC(@ifcheck)
if(@no=1)
BEGIN
set @count =(select count(*) from Dept where EID like @ename)
if(@count = 1)
begin
select * from dept where EID = @ename
END
else
set @notpresent ='not present'
end
else
if(@no = 0)
BEGIN
set @count =(select count(*) from Dept where ename like @ename)
if(@count = 1)
BEGIN
select * from dept where ENAME = @ename
END
else
set @notpresent ='not present'
END
if(@count = 0)
BEGIN
select @notpresent
END
END

--exec dpt @ename = 'maths'