• davidandrews13 (11/21/2014)


    i've been trying to get TRY_CONVERT to work but it states its an unrecognized built in function for sql server 2012 (even though sql server *does* recognises it because i get it in the intellisense, and its not underlined as unrecognised)

    i note that the compatibility mode for the database is sql server 2008 (100).

    but surely that would mean IIF wouldn't work either? but that works fine.

    reference: http://stackoverflow.com/questions/22310486/try-convert-fails-on-sql-server-2012

    http://msdn.microsoft.com/en-us/library/hh230993.aspx

    DECLARE @int INT = 1

    DECLARE @varchar VARCHAR(50) = 'david'

    SELECT

    CASE WHEN TRY_CONVERT(INT,@varchar) IS NULL THEN 'failed' ELSE 'succeeded' END AS result

    anyone see what i'm doing wrong?

    Compatibility level of your database?

    Gerald Britton, Pluralsight courses