ejwswtmbbv
New Member
Okay, I have a table that has a column named 'bdParameters', datatype is text. The data stored in the bdParameters column is XML saved as text. The data goes like this:\[code\]<root><row statusID="ALL" subID="ALL" viewMaskFields="false" masID="219" userID="13" prptyDate="08/19/2011" docID="21b15c9e-76a5-44ed-afbb-96b6df2cf881" resmID="8806" leaID="6345" reshID="3560" doEmail="" emailFrom="" emailTo="" emailMsg="penarands" emailSubject="" fieldList="1" fmtID="2" OptInCES="Yes" SendVaiEmailCES="1" RPIPMCURL="lm-10-254-9-52.onesitedev.realpage.com" /><Custom><UpdateResidentLetter><Row Status="NOTPRINTED" Notes="Created from bulk letters interface" /></UpdateResidentLetter></Custom></root>\[/code\]I want to be able to select only the attribute 'emailMsg' from that xml. is that possible? If so, how?