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