You can both use sql selects, and updates...
eg:
SELECT FirstName, LastName, MyColors
FROM Table1;
FirstName LastName MyColors
David Smith Blue
albert kallal Blue, Green
So, in the above, the "mycolors" is a multi- valued list of a persons
favorate colors. (and, for simple sake, this is another talbe, but the
primary key is not a id..but is the actual color name).
Lets change Blue to Red.....
UPDATE table1 SET MyColors.[Value] = "Red"
WHERE MyColors.Value = "Blue";
Now, lets select again:
SELECT FirstName, LastName, MyColors
FROM Table1;
FirstName LastName MyColors
David Smith Red
albert kallal Green, Red
So, yes, you can run selects, or updates on that mult-valued field.
