JOIN and forcing UPPERCASE?

[JA3395]

I'm trying to perform an inner join on two text fields, the contents of the field are mixed case values.

Is there any way I can perform the equivalent of

INNER JOIN ON UPPER(csid_det.csid_part) = UPPER(qryPt_mstr.pt_part);

which of course Access will not allow!

An alternative would be to be able to force UPPERCASE during the Import stage, is this possible?

Thanks in anticipation!

J.

 

[PHV]

Access is case insensitive by default, so the following should work:
FROM csid_det INNER JOIN qryPt_mstr ON csid_det.csid_part = qryPt_mstr.pt_part

BTW, in JetSQL use UCase instead of UPPER

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[bendixen]

Of course if you wanted to force the case value to only be upper case you could use...

Private Sub
If KeyAscii > 96 And KeyAscii < 123 Then
KeyAscii = (KeyAscii And 223)
End If

End Sub

...it basically converts any lowercase value you enter to show the uppercase value of the same letter. I use this on AfterKeyPress on one of my form boxes.

Hope that helps.