SQL Server, how to convert nvarchar to numeric

Rookie one, when doing the project today, suddenly encountered a problem:

The nvarchar type of "time" stored in the database, for example: ' 08:00 ', and I need to make a range comparison of time, then I think of converting the nvarchar type to int type.

There is a problem, ' 08:00 ', in the middle there is a ":", which is more annoying.

To convert to a number, it must be a pure digital string, that is, remove the superfluous ":", Method:

cast (replace(string,' need to replace character ','asint')

This will solve the problem.

SQL Server, how to convert nvarchar to numeric