OK so I'm drawing a blank on this one. I have a field in one table that is Order# ' ' line# + release#. Sometimes the order # is 5 characters, sometimes 6. Line# can be 1 to 6 digits, release# does not always exist but when it does it is 3 characters. I need to extract the line# to use in the join statement.
Sample data
000835 2 = order# 000835 line# 2
001024 3000 = order# 001024 line# 3 release# 000
T9342 2 = order# T9342 line# 2
T9276 5000 = order# T9276 line# 5 release#000
I need to join
from table1 join table2 on table1.fcmaster = table2.fsono and table1.line# = table2.finumber
any ideas on how to parse the data out so I can use it in the join?
Sample data
000835 2 = order# 000835 line# 2
001024 3000 = order# 001024 line# 3 release# 000
T9342 2 = order# T9342 line# 2
T9276 5000 = order# T9276 line# 5 release#000
I need to join
from table1 join table2 on table1.fcmaster = table2.fsono and table1.line# = table2.finumber
any ideas on how to parse the data out so I can use it in the join?