How to replace char in Ntext field

S

sausmus

Joined
May 24, 2006
Messages
5
Reaction score
0
I need help on replace char in ntext data type

Here is the example data
<qMultipleChoice><qText>The%20AE%20understands%20what%20conditions%20the%20Account%20Manager%20is%20allowed%20to%20sign-off
20on.</qText><qChoice>Strongly20Disagree</qChoice><qChoice>Disagree
</qChoice><qChoice>Agree</qChoice><qChoice>Strongly%20Agree</qCh

I want result look like this(break 2 parts)
First Column:The Understands what conditions the Account Manager is allowed to sign-off.
Second Column: Strongly Disagree Disagree Agree Strongly Agree

This is what i had so far
Select (SUBSTRING(QuestionText, (PATINDEX(N'%<qText>%', QuestionText) + 7),(PATINDEX(N'%</qText>%', QuestionText) - (PATINDEX(N'%<qText>%', QuestionText) + 7)))) From tblExample

my result:
The%20AE%20understands%20what%20conditions%20the%20Account%20Manager%20is%20allowed%20to%20sign-off%20on.

I have problem replace '%20' and how to make the second column.
Any Help?
Thanks
Shan
 
Top