Cast int to varchar

by

You will need to cast or convert as a CHAR datatype, there is no varchar datatype that you can cast/convert data to:

select CAST(id as CHAR(50)) as col1 
from t9;

select CONVERT(id, CHAR(50)) as colI1 
from t9;

See the following SQL — in action — over at SQL Fiddle:

/*! Build Schema */
create table t9 (id INT, name VARCHAR(55));
insert into t9 (id, name) values (2, 'bob');

/*! SQL Queries */
select CAST(id as CHAR(50)) as col1 from t9;
select CONVERT(id, CHAR(50)) as colI1 from t9;

Besides the fact that you were trying to convert to an incorrect datatype, the syntax that you were using for convert was incorrect. The convert function uses the following where expr is your column or value:

 CONVERT(expr,type)

or 

 CONVERT(expr USING transcoding_name)

Your original query had the syntax backwards.

More Related Contents:

  1. how to delete data from table A besides the customer service and director data in table B?
  2. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  3. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  4. Error Code: 2013. Lost connection to MySQL server during query
  5. MySQL Trigger after update only if row has changed
  6. Error creating table: You have an error in your SQL syntax near ‘order( order_id INT UNSIGNED NOT NULL AUTO_INCREMENT, user_id ‘ at line 1 [duplicate]
  7. MySQL Query to select data from last week?
  8. Using an Alias in SQL Calculations
  9. Can a table field contain a hyphen?
  10. Adding a leading zero to some values in column in MySQL
  11. How do I add a custom CHECK constraint on a MySQL table?
  12. MySQL/MariaDB – order by inside subquery
  13. View’s SELECT contains a subquery in the FROM clause
  14. How to insert data to MySQL with auto-incremented column(field)?
  15. Case statement in MySQL
  16. Replace Into Query Syntax
  17. How to produce “phantom read” in REPEATABLE READ? (MySQL)
  18. Laravel join with 3 Tables
  19. Difference between two table structure
  20. MySQL query, MAX() + GROUP BY
  21. How to get multiple records against one record based on relation?
  22. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  23. Foreign key constraints: When to use ON UPDATE and ON DELETE
  24. How to use a user variables in MySQL LIKE clause?
  25. MySQL – SELECT * INTO OUTFILE LOCAL ?
  26. How to speed up sql queries ? Indexes?
  27. Selecting distinct 2 columns combination in mysql
  28. How to store a one to many relation in MySQL database?
  29. MySQL – Complexity of: SELECT COUNT(*) FROM MyTable;
  30. MySQL: Computed Column

Leave a Comment