O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The TRY_PARSE Function

Like PARSE, the TRY_PARSE function can be used to convert any string value to a numeric or to a date and time format if SQL Server cannot convert the passed value to numeric or to a date and time format, it will return a NULL value rather than raising an error, as shown in Listing 44.5. In this example, you see how PARSE raises an error trying to convert the value 'CA' to an int and that no result set is returned, whereas TRY_CONVERT returns a result set with a value of NULL returned instead of raising an error.

LISTING 44.5 Comparison of PARSE and TRY_PARSE Behavior

SELECT  StateProvinceID ,StateProvinceCode ,PARSE(StateProvinceCode AS INT) AS [Using PARSE Function]FROM Person.StateProvince ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required