How to join when data isn't quite equal...?

[blarson0]

Hi! I need to have some tables join, but the fields won't be quite equal. The assy field in one table will be the full assy number, but in the other table it will only be part of it. For example:

Table 1:
Assy Num
78463-RAP-04
72400-LFW-04
78461-RAV-04
78461-RLM-04
etc...

Table 2:
Assy Num Desc
78463 Motor 1
72400 Motor 2
78461 Motor 3

so when the first parts are the same, it should join. I tried using a LIKE instead of = in the join statement, but no dice. any ideas?

Thanks!

-Brad

 

[cheerio]

If you always want the first 5 characters join using the LEFT function.

Ken

 

[blarson0]

Thanks Ken!

I was worried about doing that, but it is working great. Thanks again!

-Brad