TRY_CAST should not throw error on long values

For the following codeDECLARE @X NVARCHAR(MAX) = 1SET @X = REPLICATE(@X, 4001)SELECT TRY_CAST(@X AS DATE)Actual resultsMsg 8152, Level 16, State 10, Line 4String or binary data would be truncated.Expected ResultsReturns NULL with no errorUsers often use TRY_CAST with columns containing heterogeneous data to work around the fact that CAST can be evaluated before a WHERE.The expectation would be that any invalid data is silently ignored and does not lead to runtime errors.Couple of recent examples...https://stackoverflow.com/q/61756457/73226https://stackoverflow.com/q/61755741/73226

New

ProgrammabilityBugs

0 Comments

You must to comment