You can give an alias to the value
select scope_identity AS Counter
>Thank you... it worked.
>
>Just out of curiosity, what column name would it be in the reader? I was able to get at it using an index of 0, but I couldn't get at it by using "scope_identity" and "counter" (which is the field name of the PK). Thanks a lot!
>
>MAC
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com