Unanswered: Selection expert matching two fields of different lengths
I have an issue in Crystal reports that I think is pretty easy but it is stumping me.
I have a table with all doses billed (we'll call it Billing) to patients and each supply or drug is assigned and eight digit code(RPC) that is stored as a string (not my call). I want to select for only those items in another database (we'll call it Drugs), it's the same number as in the previous EXCEPT that it is a seven digit code. I have it stored as a string. I was unable to do a compare with one of them being seven digits and one being eight. I have a COPY of drugs that I made and eight character string.