EN
MS SQL Server - convert value to CHAR (using CAST() function)
0 points
In this article, we would like to show you how to convert a value to CHAR type using CAST() function in MS SQL Server.
Quick solution:
xxxxxxxxxx1
SELECT CAST(value AS CHAR);In this example, we will convert INT value to CHAR type.
Query:
xxxxxxxxxx1
SELECT CAST(100 AS CHAR) AS 'int_to_char';Result:
To show how to convert value to CHAR, we will use the following values table:
Note:
At the end of this article you can find database preparation SQL queries.
In this example, we will convert max_value column (which is INT type) from values table to CHAR type.
Query:
xxxxxxxxxx1
SELECT2
[id], [min_value], [max_value],3
CAST([max_value] AS CHAR) AS 'max_value_char'4
FROM [values];Output:
create_tables.sql file:
xxxxxxxxxx1
CREATE TABLE [values] (2
[id] INT IDENTITY(1,1),3
[min_value] INT,4
[max_value] INT,5
PRIMARY KEY ([id])6
);insert_data.sql file:
xxxxxxxxxx1
INSERT INTO [values]2
([min_value], [max_value])3
values4
(1000, 1500),5
(1500, 2000),6
(1400, 2500),7
(1200, 3000),8
(1800, 3500);