Breaking News
recent

SQL Server Convert String to Number

This is how to convert a string to number to an SQL Server sentence.




SELECT CAST(YourVarcharCol AS INT) FROM Table

examples

Convert to Integer
Select Cast(Customers.CodeId as Int) from Customers

Convert to a real
Select Cast(Customers.CodeId as float) from Customers
Προμηθέας

Προμηθέας

Powered by Blogger.