mashikoo (9/7/2010)
Here is the an example of the end result:Last name first name Status
Doe John A
You really don't like to read the article, do you?
How about adding ,'A' AS Status to your query?
It won't give you the posid column as requested in an earlier post but your requirements may have changed in between...