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 8 (of 8 total)

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

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy