I am using this:
select ultra region ,
max((case when ultra region like '%regional banking' then left(ultra region,then(ultra region)-16 else ultra region end)) custcol_32.
I need to remove regional banking text from ultra region col.Its repeating in all the elements of ultra region colunm.
SEL OREPLACE ( ' regional banking of abcd' , 'regional banking', '')
--in your case
SEL OREPLACE ( ultra_region, 'regional banking' , '') FROM lu_region
You can use Oreplace to remove a substring in a string.