[MS_AccessPros] Extracting left most number through query

 

Dear All

I have a product table with product name like following in it

EM1 udr 3
C1/2 HW dr 4 C1 MM udr 5/0 C1 UM udr 10/0 H2 dr 10
C1 SEL udr 18/0
C1/2 EL udr 18/0
EL1 F 16/0

I am trying to create a query to extract the left most number from product
name let say

from EM1 udr 3 I want to extract 3
from C1/2 HW dr 4 I want to extract 4
from C1 MM udr 5/0 I want to extract 5/0 and so on...

any idea??

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 4
• New Links 1
• New Files 2

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___