Thanks for reply
"SELECT [DBChanges].* FROM [Checklists].dbo.[DBChanges] WHERE [Permited_by].exist('/Root/Row/User/.[fn:upper-case(.)= ("SHW","SKT","PRS")]')>0" will work very well
But then I thought i should use IN in query.After searching sometimes i found this query
where [Permited_by].value('(Root/Row/User)', 'varchar(50)') IN ('Shw','skt','prs')
But this query will match with user only in first row because of using '(Root/Row/User)'
.How can i madify this to match with whole XML row?