Which Column Has the Data?

I have a table with 4 columns "ID" "ColA" "ColB" "ColC". One of them
has the value "xxx", the others are null. My SQL is

Select ID From MyTable Where ColA='xxx' or ColB='xxx' or ColC='xxx'

But In addition to ID, I also want to know which column has 'xxx'. How
can I modify my SQL Server 2000 TSQL to know which has the data?

Thanks.

Try something like this (untested):

Select ID,
SUBSTRING(CASE WHEN ColA='xxx' THEN ',ColA' ELSE '' END
+CASE WHEN ColB='xxx' THEN ',ColB' ELSE '' END
+CASE WHEN ColC='xxx' THEN ',ColC' ELSE '' END,2,8000) AS Col
>From MyTable Where ColA='xxx' or ColB='xxx' or ColC='xxx'

Razvan