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

User · Accepted Answer

Use the convert function   SELECT CONVERT varchar 10   field name  FROM table name

User · Answer

Actually you don t need to use STR Or Convert  Just select  xxx  LTRIM ColumnName  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

User · Answer

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

User · Answer

You can use CAST function   SELECT CAST your column name AS varchar 10   FROM your table name

User · Answer

SELECT cast CAST  field name  AS bigint  as  nvarchar 255   FROM table name

User · Answer

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

[sql] Convert INT to VARCHAR SQL

Examples related to sql

Examples related to select

Examples related to type-conversion

Examples related to sybase