return number

[Jeff Klein]

can someone tell me how to return a line in my query that shows the first
number in this field : S-7L/8L

result = 7

 

[Jason Lepack]

Number or digit?

What is the expected result of this:
S-72L/8L

You might have to create a Function to find this result.

Cheers,
Jason Lepack