Error ' 'numeric' is not a recognized built-in function name. '

Question

I want to convert data type from nvarchar to numeric, but receive an error:

numeric is not a recognized built-in function name.

Which the other device can be used normally:

SELECT TRY_CONVERT(numeric(38,2),Usage_Amount) as Result
    FROM [MMS].[dbo].[Tooling_DieCut]
    WHERE Tooling_Type = 'Solid Tool'

Microsoft SQL Server 2016

VVD__27 · Accepted Answer · 2020-03-19 05:04:41Z

2

Use Decimal instead of Numeric...

SELECT TRY_CONVERT(decimal(38,2),Usage_Amount) as Result
    FROM [MMS].[dbo].[Tooling_DieCut]
    WHERE Tooling_Type = 'Solid Tool'

answered Mar 19, 2020 at 4:44

VVD__27

416 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1