SQL sum numbers in text

This is the code

select 'QWXWX/50,GNTGHNT/5,F/500'  

I want to see sum of the numbers in this texts. My expectation result is 555.

>Solution :

You shouldn’t do this in T-SQL, but anyway you still could if you wanted to:

with basedata (data) as 
(
  select * from string_split('QWXWX/50,GNTGHNT/5,F/500',',')
)
select sum(cast(replace(data, rtrim(translate(data, '0123456789',space(10))), '') as int))  from basedata;

DBFiddle demo

Leave a Reply