T-SQL Arithmetic overflow error converting GUID to any other data type

I have a query where I'm trying to concatenate a GUID to a string. No matter what I do, or what I try to convert the GUID to, I get an arithmetic overflow error. Even this:

select CAST( NEWID() as nvarchar)

Returns: Msg 8115, Level 16, State 2, Line 1 Arithmetic overflow error converting expression to data type nvarchar.

All similar questions have been resolved by a CAST or CONVERT but this always returns an error. Same result for CHAR or VARCHAR. Is there a setting I have to change to make this work or something?

https://stackoverflow.com/questions/65963957/t-sql-arithmetic-overflow-error-converting-guid-to-any-other-data-type January 30, 2021 at 10:07AM