'Trim string before numbers (0-9) in SQL

I want to remove all the letters before numbers in the below strings:

BIO105L
BIO106
BIO106L
BIO201

I want the letters after the number to stay and not trimmed.

I tried to do this:

select right(s.EVENT_ID, len(s.EVENTID) - charindex('%[^0-9]%', s.EVENT_ID))
from EVENTS s

Can someone help?

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source