I am working on a stored procedure and I have 2 strings that need to be compared and if the 2 of them contain 6 characters which are the same at any position of either one, it should return 'Equal' otherwise 'Not Equal'
0010723543289035 should be equal to 137107235ABC001 since the 2 strings contain '107235'
5272235 should not be equal to 123891113
Can please anyone help me? Any ideas would be appreciated.