By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select
reverse(value) from (
select * from
STRING_SPLIT(reverse('Make\Model\Trim\New'), '\',1)
)t where
ordinal = 2
| (No column name) |
|---|
| Trim |
| (No column name) |
|---|
| Trim |