Home Forums SQLServerCentral.com Editorials Is It Time To Clear Out Those Quirky Functions? RE: Is It Time To Clear Out Those Quirky Functions?
JustMarie
SSCertifiable
Points: 7771
More actions
July 18, 2014 at 10:06 am
#1730687
We got hit by ISNUMERIC early. It will convert text that happens to be valid hexadecimal into a positive hit. So we went to PATINDEX to find values that were numeric. So in the background it does conversion checks. :ermm: