EN
MS SQL Server - CAST() function example
0
points
In this article, we would like to show you CAST() function example in MS SQL Server.
Quick solution:
SELECT CAST(value AS DATA_TYPE);
Note:
Go to the official documentation to see available
DATA_TYPES.
Practical example
In this example, we will convert INT value to CHAR type using CAST() function.
Query:
SELECT CAST(100 AS CHAR) AS 'int_to_char';
Result:
Note:
Go to this article to see how to convert columns using
CAST()function.