I have a CAML query
<Query><Where><Or>"+ "<Eq><FieldRef Name='UserName' /><Value Type='User'>" + User.Name + "</Value></Eq>"+ "<Contains><FieldRef Name ='OtherUsers'/><Value Type = 'Note'>" + site.CurrentUser.Name + "</Value></Contains>"+ "</Or></Where></Query>
This works and brings desired results. Now coming to the issue
The OtherUsers column holds the list of selected users in .csv format.
Say if User1&User11 are selected the column will contain
When User11 is selected the column will just have
Now according to the query, when
User1 logs in, it will bring the record containing
OtherUsers column as
How can I overcome this issue?