Remove vowels from string

[outofservice]

I have two columns (ColumnA and ColumnB)
ColumnA contains text strings, ColumnB is empty

Id like to update ColumnB with the string values of ColumnA but I want to remove all vowels during the update.

How do I do this?
Thanks,


Lauryn Bradley
SQL Server DBA

 

[swampBoogie]

update t 
   set columnB = replace(replace(columnA,'A',''),'E','')

You can add further replace.