You can first select into a temp table to get required order and assign seq. numbers using IDENTITY column.

drop table #temp
create table #temp (
	SeqNum int IDENTITY(1, 1), 
	FirstName varchar(32) NOT NULL)
INSERT INTO #temp (FirstName) SELECT FirstName FROM Employees ORDER BY FirstName
SELECT * FROM #temp 
	WHERE ((SeqNum) % 100) = 1

>I want to provide hotlinks titled something like:
>"001 Anne, 101 Henry, 201 Nancy... " where Anne, Henry and Nancy are the 1st, 101st, 201st ... etc entries in the table when considered in FirstName Order.
>How can I easly construct this string with the data in a SQL server Table.