Advertisement
Advertisement


Convert INT to VARCHAR SQL


Question

I am using Sybase and I am doing a select which returns me a column called "iftype", but its type is int and I need to convert into varchar. When I try to do the select without the convert function I get this error:

Error code 257, SQL state 37000: Implicit conversion from datatype 'VARCHAR' to 'INT' is not allowed. Use the CONVERT function to run this query.

I dont know how to implement the function CONVERT. Can anyone help me, please ?

2015/03/06
1
351
3/6/2015 8:05:19 PM

Accepted Answer

Use the convert function.

SELECT CONVERT(varchar(10), field_name) FROM table_name
2015/03/06
604
3/6/2015 8:01:37 PM

Use the STR function:

SELECT STR(field_name) FROM table_name

Arguments

float_expression

Is an expression of approximate numeric (float) data type with a decimal point.

length

Is the total length. This includes decimal point, sign, digits, and spaces. The default is 10.

decimal

Is the number of places to the right of the decimal point. decimal must be less than or equal to 16. If decimal is more than 16 then the result is truncated to sixteen places to the right of the decimal point.

source: https://msdn.microsoft.com/en-us/library/ms189527.aspx

2017/01/11

You can use CAST function:

SELECT CAST(your_column_name AS varchar(10)) FROM your_table_name
2016/11/06

Actually you don't need to use STR Or Convert. Just select 'xxx'+LTRIM(1) does the job. Possibly, LTRIM uses Convert or STR under the hood.

LTRIM also removes need for providing length and usually default 10 is good enough for integer to string conversion.

SELECT LTRIM(ColumnName) FROM TableName
2020/02/18

SELECT cast(CAST([field_name] AS bigint) as nvarchar(255)) FROM table_name

2020/07/24

CONVERT(DATA_TYPE , Your_Column) is the syntax for CONVERT method in SQL. From this convert function we can convert the data of the Column which is on the right side of the comma (,) to the data type in the left side of the comma (,) Please see below example.

SELECT CONVERT (VARCHAR(10), ColumnName) FROM TableName
2020/02/18