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

select *

from [Checklists].dbo.[DBChanges]

where [Permited_by].value('(Root/Row/User)[1]', 'varchar(50)') IN ('Shw','skt','prs')

But this query will match with user only in first row because of using '(Root/Row/User)[1]'.How can i madify this to match with whole XML row?