TRY_CONVERT() function syntax with an example in SQL Server

TRY_CONVERT() function syntax with an example in SQL Server

Introduction: 

In my previous posts we have seen what is Transact-Sql in sql server and What are new top features of T-Sql in server. This is one of the best sql server interview Questions and answers. Watch more ASP.NET, C#.NET, Jquery, Sql Server, HTML5, HTML, CSS, JQUERY UI Interview questions from here. 

Description: 

·        This function returns a value cast to the specified data type if the cast succeeds, otherwise returns null.

Example:

 SELECT

    CASE WHEN TRY_CONVERT (float, ‘test') IS NULL

    THEN 'Cast failed'

    ELSE 'Cast succeeded'

END AS Test_Convert;

GO

Result:

Cast failed

If you have any queries or suggestions, please feel free to ask in comments section.