Please check below query.

Note: Please replace table name with your table name in select and update statements.

DECLARE @T1TBL TABLE(ItemNum VARCHAR(50))

INSERT INTO @T1TBL
SELECT...

Carlo Romagnano (3/2/2016)

When execute below code then error message come, not * (star).

SELECT TRY_CONVERT(VARCHAR(1), 234523)

An error

Msg 195, Level 15, State 10, Line 1

'VARCHAR' is not a recognized built-in function name.

When...

SQL Server 2012

When execute below code then error message come, not * (star).

SELECT TRY_CONVERT(VARCHAR(1), 234523)

An error

Msg 195, Level 15, State 10, Line 1

'VARCHAR' is not a recognized built-in function name.

When execute below...