Viewing 3 posts - 1 through 4 (of 4 total)
GSquared (4/7/2009)
You could throw a multi-character wildcard in there, after the first number and before the "mm", but that might get...
April 7, 2009 at 2:21 pm
#973811
Sergiy (4/7/2009)Using of 1st Normal Form would help a lot here.
Sergiy (4/7/2009)
External data - I get the fun job of normalizing it :w00t:
April 7, 2009 at 2:19 pm
#973809
Nevermind...
select patindex('% [0-9][0-9][0-9]mm%', 'RockShox Tora SL Le Femme, 100mm-travel w/lockout')
:ermm:
Is there any way to check for a numeric value, no matter how many digits it has?
April 7, 2009 at 1:57 pm
#973782