how get the value from the string

Hi,

I wonder how can you select the numbers but it will cut after the space.

Here's the example string
I know theres tricky how to do it that like instr in access that i have to combined with select right(' ',5) but the string numbers varies but how can i tell on my query it should stop selecting when it reaches the space in between the dash?
appreciate your help

re: how get the value from the string

Hey.

Try the SUBSTRING_INDEX function.

I have to ask tho, why do you need to do this?
This sort of thing should be done by whichever front-end software is using your database.

Unless you are actually storing those strings inside your database, in which case you might want to reconsider your table design.