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.
--sb--