sql - 将INT转换为VARCHAR SQL(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.

(我正在使用Sybase，我正在做一个select，它返回一个名为“iftype”的列，但它的类型是int，我需要转换为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.

(错误代码257，SQL状态37000：不允许从数据类型“VARCHAR”到“INT”的隐式转换。)

Use the CONVERT function to run this query.

(使用CONVERT函数运行此查询。)

I dont know how to implement the function CONVERT .

(我不知道如何实现CONVERT函数。)

Can anyone help me, please ?

(有人可以帮帮我吗？)

  ask by Murilo translate from so

Answer 1

使用转换功能。

SELECT CONVERT(varchar(10), field_name) FROM table_name