改进搜索表匹配字符串的SQL函数

I have a function that searches a for a matching ICD-9 code in another table character by character. I am doing this because the format that we receive ICD-9 codes in is not consistent and many of them have extra numbers on the end or they may have a decimal in the wrong place or even missing. I have a function that searches a for a matchin