Post reply

COUNT a char in a VARCHAR

  • November 23, 2005 at 6:49 am

    #90925

    How do I count the frequentie of a char within a varchar?

    "like if we do it for: i" -> 4

  • November 23, 2005 at 7:13 am

    #605455

    DECLARE @a VARCHAR(30)

    SET @a = 'like if we do it for: i'+'x'

    SELECT LEN(@a), LEN(REPLACE(@a, 'i', ''))

                           

    ----------- -----------

    24          20

    (1 row(s) affected)

    Caution when there is a space at the end of the REPLACed string. In that case you need to add a dummy string at the end, otherwise you'll get wrong results.

    DECLARE @a VARCHAR(30)

    SET @a = 'like if we do it for: i'

    SELECT LEN(@a), LEN(REPLACE(@a, 'i', ''))

                           

    ----------- -----------

    23          18

    (1 row(s) affected)

     

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • November 23, 2005 at 7:14 am

    #605456

    Btw, are you the guy who has developed the Mambo/Joomla Bookmarks component?

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • November 23, 2005 at 7:18 am

    #605458

    No I'm not, thx for your solution

Viewing 4 posts - 1 through 3 (of 3 total)

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