mercredi 14 janvier 2015

How to perform a TRY_CAST in SQL SERVER 2005?

I'm try to perform a TRY_CAST in SQLSERVER 2005. The query will look like: SELECT TRY_CAST((select bla bla bla expression) as int),


The expression inside the try_cast might return some strings or something which cannot be converted as INT, that's why I need it (obviously :) ). Unfortunately I wrote my big query for sql server 2012, but now I need to use it on a sql server 2005.


Is there a workaround?


Thank you!


Aucun commentaire:

Enregistrer un commentaire