Re: Using the REPLACE command to replace all vowels

On 1 May 2006 13:16:15 -0700, EbGrooveCb <cbaumann(at)cmsgrp(dot)com> wrote:
> Is there a way to make seperate replacements in 1 field in one command
> in SQL?
>
> I need to remove all vowels (a,e,i,o,u) in a field. How would I go
> about that?
>

You can do all the replacements in a single SQL statement by nesting
the REPLACE statements. This will just strip those letters.

SELECT
REPLACE(
REPLACE(
REPLACE(
REPLACE(
REPLACE(
'Your string or field here.'
,'a','')
,'e','')
,'i','')
,'o','')
,'u','')
;