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:04 am

    #1588370

    doesn't this do it?

    DECLARE @noVowels [varchar](50)

    SET @noVowels = 'Information System'

    SELECT

    REPLACE(

    REPLACE(

    REPLACE(

    REPLACE(

    REPLACE(@noVowels,'A','')

    ,'E','')

    ,'I','')

    ,'O','')

    ,'U','')