SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Atif Sheikh / Count Number of Words and Characters / Latest Posts

RE: Count Number of Words and Characters

Atif-ullah Sheikh — Sat, 31 Jul 2010 12:50:11 GMT

[quote][b]The Danish Dynamo (7/30/2010)[/b][hr]i posted that solution years ago, you just copied it and messed it up, please delete it[/quote]Really :w00t:? And how "messed up"?

RE: Count Number of Words and Characters

The Danish Dynamo — Fri, 30 Jul 2010 11:15:15 GMT

i posted that solution years ago, you just copied it and messed it up, please delete it

RE: Count Number of Words and Characters

Atif-ullah Sheikh — Tue, 27 Jul 2010 22:22:17 GMT

WHILE loop is there by mistake (was testing something before posting it). Please ignore it.

RE: Count Number of Words and Characters

lizardalpha — Tue, 27 Jul 2010 03:47:08 GMT

ra.shinde, you are correct, the while loop will never end. Besides from your first function you can derive the word count as well. See code below:-- Number of specific CharactersDeclare @aa varchar(100)Set @aa = 'SQL Server 2005 Atif Sheikh A'Select Len(@aa) - Len(Replace(@aa, ' ', '')) + 1

RE: Count Number of Words and Characters

ra.shinde — Tue, 27 Jul 2010 03:07:11 GMT

If I am not wrong, that while loop will never end.

RE: Count Number of Words and Characters

kishor.raskar — Tue, 27 Jul 2010 00:19:38 GMT

Hello sir in your number of words count code, what is use of while block because it is done without using while block

Count Number of Words and Characters

Atif-ullah Sheikh — Mon, 26 Jul 2010 23:36:49 GMT

Comments posted to this topic are about the item [B]Count Number of Words and Characters[/B]