PARSE (Transact-SQL)

Returns the result of an expression, translated to the requested data type in SQL Server. ... Category Type.NET Framework type Styles used Numeric bigint Int64 NumberStyles.Number Numeric int Int32 NumberStyles.Number Numeric smallint Int16

msdn.microsoft.com