When I run that select statement in SQL Server 2008 (10.0.5538) I get the error:
SELECT TRY_CONVERT(NVARCHAR(1), 234523)
Msg 195, Level 15, State 10, Line 1
'NVARCHAR' is not a recognized built-in function name.
Is there something in my DB settings that would generate this? I'm pretty sure they're using the install defaults.
Or did I miss some part of the statement when I copied it?