CONVERT keyword

[Timcwilcox]

I have a SQL table with a VARCHAR element that contains a number, i want to read this with a convert(numeric) statement, but it stops the SQL script when it reaches a value that is not numeric. How can i get the SQL script to wither skip past the data item, or use zero?

 

[jester777]

You could use the ISNUMERIC function to test whether the varchar field contains something that SQL recognises as a number before trying the CONVERT.

 

Thanks, this was the correct solution.