THanx for your help.

I am going to have to look at this and figure it out. 

I'd like to say that I am doing it cause of excessive need, but I cannot.

I am going by the specs someone else drew up and trying to match it. ...

Sorry.. I missed the second part...

It is only in the select..

The current select pulls about 100 000 records, but I doubt the seq# would ever be more than 100.

The application is:

You have a sales order number 85678.  That sales order...

Thank you very much.. it works well.

There is only one thing I do not understand.  What is the command 'dtMajorVersion' mean?

Alright although sp_helpuser is not what I was looking for it lead me to the command

exec sp_helprolemember 'role'

Thanx

oops wrong forum...