Step 1: Create A Table and Insert Data
- Create table tblTemp (ID int identity not null, Alphanumeric nvachar(10))
- insert into tblTemp (AlphaNumeric) values ('123')
- insert into tblTemp (AlphaNumeric) values ('abc')
- insert into tblTemp (AlphaNumeric) values ('bcd')
- insert into tblTemp (AlphaNumeric) values ('kamal')
- insert into tblTemp (AlphaNumeric) values ('456')
- insert into tblTemp (AlphaNumeric) values ('678')
- insert into tblTemp (AlphaNumeric) values ('eft')
- insert into tblTemp (AlphaNumeric) values ('123')
Step 2: See All Recored
- SELECT * FROM dbo.tblTemp
Step 3: See All Numeric Record
- SELECT * FROM dbo.tblTemp WHERE ISNUMERIC(AlphaNumeric) = 1