Can anyone advise how to return a result from a table where the column being search contains 'wildcards' ?
FYI, I use the wildcard term loosely as some true wildcards have been replaced, in this case an asterix is replaced by a small "x" at the end of a string. The table being searched contains a list of rules to convert accounts from system1 to system2, based on a concatenated search string from system1, So, if I have a search string of "ABC12349" from system1, how would I get "XYZ12340" from the following:
Rule System2 Account
One important point to note.....it is common multiple rules can apply to the search string, however only 1 rule should apply, therefore rules are prioritised based on closest to a full match, as per the following examples:
Search System2 Account
ABC99999 No Rule
Can anyone help?
I'm using Microsoft SQL Server 2014 and MS Office 2013.
Thanks in advance