July 21, 2011 at 9:09 pm
I think we are in agreement. That is some slick code. Tomorrow I will put together the actual loop on real data. This just made my life a lot easier. Maybe not mine but the person that has to eye ball these duplicates. Thanks everyone. 😛
July 21, 2011 at 9:14 pm
I'm glad it helped. I guess my backwards thinking is a good thing at times.
Also you might want to start with char(32) in case there is a [space] between the characters that you are looking to compare within the ranking. also a rtrim(ltrim(theFieldName)) may be helpful in the code.
Just another thought... after running the ascii loop you may want to look for the patindex if the length of the field is 10 start with comparing the first character of the value and compare it to the first character of the Name... then add +1 if matches ... then look for the patindex of the first 2 if matches + 1 more ... then 3,4 up to the length of 10
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply