How to fix Msg 245, Level 16, State 1, Line 3 Conversion failed when converting the nvarchar value 'N/A' to data type int. on SQL

Question

Hey guys

I am using this code
SELECT*

FROM [dim].[ServiceOrder] AS SO

INNER JOIN [dim].[Turbine] AS TB ON SO.[Room] = TB.[Unitid]

WHERE

[ServiceOrderStatusOrderNumberText] = 'Planned'

AND [TB].[SBU] = 'LAT'

and [ScheduledStart] > GETDATE()

I shows this error: Msg 245, Level 16, State 1, Line 3

Conversion failed when converting the nvarchar value 'N/A' to data type int.

can you guys help with that?

Answer 1

Hi @Arthur Felipe do Lago Montenegro

Try using TRY_CAST() or TRY_CONVERT() to convert the nvarchar value to data type int. If the conversion fails, it returns NULL.

FROM [dim].[ServiceOrder] AS SO
INNER JOIN [dim].[Turbine] AS TB ON Try_Cast(SO.[Room] As int) = TB.[Unitid]

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".