SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE YourTable (YourColumn nvarchar(MAX));

INSERT INTO YourTable
VALUES('<TablePhoneHome><Number Num="1111"/></TablePhoneHome>')
1 rows affected

ALTER TABLE YourTable ALTER COLUMN YourColumn xml;
SELECT YourColumn.value('(TablePhoneHome/Number/@Num)[1]','int') AS Num
FROM YourTable


Num


1111