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