SQL Query

[ncopeland]

I have two tables. I want to join them. The field in the first table is a 4 character field. The second table has a field that is 8 characters long. I want to join the 4 character field to the field in the second table. The problem is the field I want to join it too needs to start at character position 2 and finish at character position 5. If this was crystal programming I would strip it out using MID(field,2,4).

Any help greatly appreciated.

 

[skuhlman]

select a.field1, b.field2
from a join b on a.keyfield = substring(b.keyfield,3,4)

 

[synapsevampire]

I think he meant:

select a.field1, b.field2
from a join b on a.keyfield = substring(b.keyfield,2,4)

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com