Post reply

Count Number of Words and Characters

  • July 26, 2010 at 11:36 pm

    #225393

    Comments posted to this topic are about the item Count Number of Words and Characters

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG     [font="Arial Black"]here[/font][/url][/right]

  • July 27, 2010 at 12:19 am

    #1198547

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

  • July 27, 2010 at 3:07 am

    #1198592

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

  • July 27, 2010 at 3:47 am

    #1198606

    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 Characters

    Declare @aa varchar(100)

    Set @aa = 'SQL Server 2005 Atif Sheikh A'

    Select Len(@aa) - Len(Replace(@aa, ' ', '')) + 1

  • July 27, 2010 at 10:22 pm

    #1199065

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

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG     [font="Arial Black"]here[/font][/url][/right]

  • July 30, 2010 at 11:15 am

    #1200481

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

  • July 31, 2010 at 12:50 pm

    #1200669

    The Danish Dynamo (7/30/2010)

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

    Really :w00t:? And how "messed up"?

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG     [font="Arial Black"]here[/font][/url][/right]

  • May 18, 2016 at 1:14 pm

    #1880005

    Thanks for the script.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply