convert NCHAR data type to INT

Question

How do i convert NCHAR data type to INT in sql server?

Answer 1

CREATE TABLE #Table(test nchar(3))

INSERT INTO #Table SELECT '111'

INSERT INTO #Table SELECT 'AAA'

INSERT INTO #Table SELECT '311'

SELECT CASE ISNUMERIC(test) WHEN 1 THEN CAST(test as int) ELSE 0 END FROM #Table

DROP TABLE #Table