Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

TSQL Challenge 62 - Break a long sentence in groups of 5 words

By Jacob Sebastian,

TSQL Challenge 62 - Break a long sentence in groups of 5 words

Read the input string and break each sentence into groups of 5 words. A row may contain more than one sentence. Each sentence in the input should start a new group.

http://beyondrelational.com/puzzles/challenges/96/break-a-long-sentence-in-groups-of-5-words.aspx

 
Total article views: 1191 | Views in the last 30 days: 1
 
Related Articles
SCRIPT

Capitalize the first letter of a sentence

I created this script to capitalize the first letter of a sentence after a space. If no space in you...

FORUM

TSQL Challenge 62 - Break a long sentence in groups of 5 words

Comments posted to this topic are about the item [B]TSQL Challenge 62 - Break a long sentence in gro...

FORUM

View sentence error

Please help with the following, I am creating a view in SQL Server 2000, the sentence is I have is t...

FORUM

Sentence Where it's not working!

have this query, but the results are not what should be

Tags
 
Contribute