I need to set mystring to equal whatever exists in the authors field. I am using this in a stored procedure. what I use to search on the field isn't working below but this isn't working when I try and set @mystring to that value.
CData field has these values <fields>
<ReqDate>1/28/2014</ReqDate>
<ReqLibrary>Main</ReqLibrary>
<Authors>Robb, King, Saul</Authors>
</fields>
HEre is what works when I just try and search using a
SELECT command:
Expand|Select|Wrap|Line Numbers
- CData.value('(/fields/Authors)[1]', 'nvarchar 255)')