t - sql ISNUMERIC(45 d 1)返回1

I have a T-Sql statement that is getting the next available number from a table. but the column is of type nvarchar. It dost have to be a number, But i still need to be able to get the next available number I have a T-Sql statement that is getting the ne