PC Review


Reply
Thread Tools Rate Thread

How to replace char in Ntext field

 
 
New Member
Join Date: May 2006
Posts: 5
 
      15th Jun 2006
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Char Char Char1 Char Char Char,Char Char Char1 Char borkena Microsoft Word Document Management 2 8th May 2008 04:36 PM
Ever seen "Char Char Char Char Char Char1 Char Char Ch" style? =?Utf-8?B?TWFyaWx5bg==?= Microsoft Word Document Management 2 4th Oct 2006 04:47 PM
Char Char Char Char =?Utf-8?B?UmFjaGVs?= Microsoft Word Document Management 2 8th Jun 2006 09:52 AM
Char Char Char Char =?Utf-8?B?UmFjaGVs?= Microsoft Word Document Management 0 7th Jun 2006 02:51 PM
Formatting changed to Char Char Char Char... =?Utf-8?B?TWVsaXNzYQ==?= Microsoft Word Document Management 10 14th Apr 2006 07:32 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:24 AM.