>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.
First shoot can be:
SELECT * From MyTable WHERE RIGHT(STR(id),1)="1"
HTH
Zlatin Zlatev,
MCSD (VS6)Make solutions, not programs!