By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE race2(
PrizeMoneyBreakDown varchar(40) );
insert into race2 values
('1st,4000'),
('1st,4550'),
('1st,4550'),
('1st,4550'),
('1st,4550');
Records: 5 Duplicates: 0 Warnings: 0
SELECT
SUBSTRING(PrizeMoneyBreakDown,5,length(PrizeMoneyBreakDown)) as st1
FROM race2
st1 |
---|
4000 |
4550 |
4550 |
4550 |
4550 |