I am trying to make a SQL query based on server name, to see if it is a test server, Production server, etc.

We have this as part of the name

example:
LLL-XXXXXE123

Where LLL is the location code
XXXXX is some discription
E is the enviroment
123 is if there are more then one of them (could be no number or up to 3)

My question is there a way to make a SQL query to filter by E?

I am trying to deploy a small package based on enviroment.

Thanks in advance for any help.