I have been using SAS for years with both Oracle and SQL Server databases. I am now on a platform that just used SQL DBF. Some of the things I could do in SAS, cannot do some I am feeling my way around,
I have a field that is 7 characters. However if all 7 characters do not match, I can match on the first five. The primary match is all 7 . The secondary match is just the first five.
Can someone tell me the best approach to achieve this is SQL.