Create index of values from different columns

Hi i have a table with different columns:
columns names: jobA, jobB, jobE....
I want to create and index with all the values(but not duplicates)
contained in all columns.
Can anybody give an idea on how to do this?
ThanksAn index? I guess you want to list all the distinct values in one column.
Like this, maybe?
select jobA
from <table>
union
select jobB
from <table>
union
select jobE
from <table>
union
...
If you wanted something else, next time please explain exactly what you
need. See this:
http://www.aspfaq.com/etiquette.asp?id=5006
ML