I have a situation where I need to join tables on a fields with different values. In one table, the patient# uses hyphens and the second table does not. I am joining the tables on patient#. Any idea how i can do this? Maybe i can create another table/qry/view that strips out the hyphen?
Here is an example of my problem,
Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.