Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Enterprise
Expertise: Advanced
Apr 12, 2002

Dealing with Delimited Strings in T-SQL for Finding Results


A string contains Yes or No answers to a series questions. How do you count the number of correct answers and wrong answers?

Here's the code:
 
DECLARE @TestResults varchar (120)
SET @TestResults = 'YES,NO,YES,NO,YES,NO,YES,YES,YES'
SET @TestResults = REPLACE (@TestResults,'YES','Y')
SET @TestResults = REPLACE (@TestResults,'NO','N')
SET @TestResults = REPLACE (@TestResults,',','')
SELECT CorrectAns = LEN(REPLACE 
(@TestResults, 'N', '')),WrongAns = LEN
(REPLACE (@TestResults, 'Y', ''))


CorrectAns  WrongAns
----------- -----------
6           3

(1 row(s) affected)
Somaiah Manukonda
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date