IsNumeric()
function, because it can often lead to data type conversion errors, when importing data. On SQL Server 2012 or later, use the Try_Convert()
or Try_Cast()
function instead. On earlier SQL Server versions, the only way to avoid it is by using LIKE
expressions. Read more