Thank you, I found it

I thought that sysindexes and sys.Indexes where the same thing

I only looked in sysindexes

Mike

I am looking for

what the WHERE clause specified

right now I know I created the index like this

CREATE INDEX IDX_indexname

ON TABLE1(StoreID,ItemsProcessed)

WHERE ItemsProcessed = 0

but If in the future, I forget...

you only have 3 items in the INTO section

but you SELECTed * from the table

unless the table only has three columns,

this presents a problem

just SELECT COLUMN,COLUMN,COLUMN

FROM table

just the three columns...

That was exactly what I was looking for

Thank you