Find substring that includes the second dash, plus one character

• jeffshelix

  SSCrazy

  Points: 2257

  More actions

  November 1, 2018 at 2:42 pm

  #380682

  ok, getting weird here.

  I need to join on this column:
  AUTO_VALUE
  5S4T-12A522-A

  But the field with the join value is the Prod_ID in another table. That PROD is like:
  5S4T-12A522-AB or 5S4T-12A522-ACD, etc.

  I am unclear on how to write the ON statement....
  Select*
  From Table_A A
  InnerJoin Table _B B
  On A.AUTO_Value = B.?????

  thoughts please? thanks

• Joe Torre

  SSChampion

  Points: 10248

  More actions

  November 1, 2018 at 2:55 pm

  #2012118

  Select *
FROM Table_A A
JOIN Table _B B
On B.Prod_ID LIKE A.AUTO_Value+'%'

• jeffshelix

  SSCrazy

  Points: 2257

  More actions

  November 1, 2018 at 3:09 pm

  #2012121

  Thanks!  i won't forget that one!