Just a small one, > select isnumeric('$+.') > 1 so it thinks it's a number but obviously it isn't > select cast('$+.' as int) > Conversion failed when conver

Just a small one, > select isnumeric('$+.') > 1 so it thinks it's a number but obviously it isn't > select cast('$+.' as int) > Conversion failed when converting the varchar value '$+.' to data type int. This kind of thing makes data cleaning even less fun than it is. They now have TryParse(), but the above (which I'm pretty sure used to allow an even wider range of crap) is just unnecessary, and is a sign of how they view their own flagship product.