Sql Server - XML

Scenario:

Sql Server - Querying xml column

Solution:

1. Query:

SELECT DISTINCT Data.value('(/category/@categoryID)[1]', 'varchar(MAX)')
                + '\'
                + Data.value('(/category/@subCategoryID)[1]', 'varchar(MAX)')
FROM   CategorySubCategoryXref
WHERE  Data.value('(/category/@name)[1]', 'varchar(MAX)') = 'MyCategory'