Thanks to both of you. I decide to just add stored procedures to encapsulate the logic.

All is well.

Thanks

Thanks Sean,

I found a data quality issue that the isnumeric was ok with the convert function was not. some values contained a '-' minus sign and the isnumeric function...