How to return the searched record along with five next records

/check this it might help/

use AdventureWorks2008R2;

declare @i int;
declare @p int;
declare @q int;
declare @RTable table (id int, name varchar(100));

set @i = (SELECT [ContactTypeID] FROM [AdventureWorks].[Person].[ContactType] where [ContactTypeID] = 5);
set @p = @i;
set @q = @i+5;

while (@p <= @q)
begin
    insert into @RTable
    select [ContactTypeID],Name FROM [AdventureWorks].[Person].[ContactType] where [ContactTypeID] = @p
    set @p = @p + 1;
    if (@p > @q)
       break;
end
select * from @RTable   

Perhaps like this?

SELECT TOP 6 * FROM Employee WHERE id >= 'E000' ORDER BY id

Personally, I do not like such alphanumeric incremented columns. You get more pains than gains unless handled as computed columns etc. In your case, if you would follow Magnus Ahlkvist's very good suggestion (which actually gives the core of the solution i.e. TOP and ORDER BY), then 'E10001' would always be sorted before 'E1001' which would not be correct. So it would always be dependent upon the LOGIC and constraints of your such alphanumeric computation of the column. If I assume that there is one alphabet and then multiple numeric characters, then one way of doing it could be

SELECT TOP 6 * FROM Employee WHERE id >= 'E000' 
ORDER BY CAST(RIGHT(id, LEN(id)-1) AS BIGINT)

But again, that could break anytime if the LOGIC of computation of the column is changed or not the same.