return number

  • Thread starter Thread starter Jeff Klein
  • Start date Start date
J

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top