Home Forums SQL Server 2012 SQL Server 2012 - T-SQL create a function to remove vowels from a given string RE: create a function to remove vowels from a given string

  • February 15, 2013 at 9:37 am

    #1588385

    byecoliz (2/15/2013)

    thank you all for that new code. Abu Dina, you're right on the return correction. Now when i do that correction the function removes only the 'A' vowel., meaning the increment is not working.how can I organize these statements so that the increment works. thank

    Forget the code that increments. Do it the way that Lynn suggested. It will be much faster than any scalar function that you can write.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)