Thought I’d add this for future reference.
Working with a column that was defined as a varchar in a database, but it was intended the contain integer values. Whatever the original purpose for this I’m not sure as I’m not the database’s author.
The program that is used to enter data also allows the input of non-numeric characters.
So, in my scenario, this could be a problem when joining onto that column in a query.
Using ISNUMERIC() in this way eliminated all non-numeric data for me.
ISNUMERIC(dbColumn + ‘.0e0’) = 1
This entry was posted by Yves on February 4, 2015 at 5:17 pm, and is filed under Databases. Follow any responses to this post through RSS 2.0.You can leave a response or trackback from your own site.