Skip to content
Fix Code Error

Convert INT to VARCHAR SQL

March 13, 2021 by Code Error
Posted By: Anonymous

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 ?

Solution

Use the convert function.

SELECT CONVERT(varchar(10), field_name) FROM table_name
Answered By: Anonymous

Related Articles

  • Is CSS Turing complete?
  • Log record changes in SQL server in an audit table
  • Understanding implicit in Scala
  • SQL query return data from multiple tables
  • Drop all the tables, stored procedures, triggers,…
  • From a Sybase Database, how I can get table…
  • Insert into not inserting for mysql
  • JSON Dump a string surrounded by single quotes and…
  • What are access specifiers? Should I inherit with…
  • How do I include certain conditions in SQL Count
  • How do I obtain a Query Execution Plan in SQL Server?
  • How to query for Xml values and attributes from…
  • Callback functions in C++
  • django-restframework. How to change many to many…
  • Can't resolve the implicit for a constrained class…
  • 3 column layout HTML/CSS
  • How to use local storage to access combined reducer…
  • How to access this variable from my store / state in…
  • Using StringWriter for XML Serialization
  • ReactJs : Nested State Not getting Updated
  • Should MySQL have its timezone set to UTC?
  • Detecting when Partial extends T
  • HQL Responding with…
  • How to filter a RecyclerView with a SearchView
  • Add pagination params to axios in Vue
  • SQL NVARCHAR and VARCHAR Limits
  • T-SQL: Export to new Excel file
  • Creating a list of single type of objects
  • no match for ‘operator
  • How do SO_REUSEADDR and SO_REUSEPORT differ?
  • How do I set initial state in Vuex 2?
  • Typescript: Type a group of partially applied…
  • SDL_SetRenderTarget() hangs for a while if multiple…
  • TypeScript metadata reflection references other…
  • How do I get the Back Button to work with an…
  • Best practices for SQL varchar column length
  • How to take backup of a single table in a MySQL database?
  • MySQL (8.0.24 Community Server - GPL) does not…
  • Design DFA accepting binary strings divisible by a…
  • Adding a new column into sqlite produces an error:…
  • Change column type in pandas
  • Find and replace entire mysql database
  • How to place object files in separate subdirectory
  • VueJS Dynamic Model Binding
  • Simulating group_concat MySQL function in Microsoft…
  • How to stop function allowing Strings or Characters?…
  • How to check if a table exists in a given schema
  • Flutter - Cubit - loaded state - managing…
  • Name type returned by inner closure
  • vue watch mapState not working
  • Search for a string in all tables, rows and columns of a DB
  • Best practice when asserting non-null on a value…
  • Failed when converting the nvarchar value to to data…
  • My submit button is not getting enabled . How do i do that?
  • vuex- state returned as function or object literal
  • NextJS - can't identify where state change is…
  • Filter Vuex state
  • No function matches the given name and argument types
  • Illegal mix of collations (utf8_unicode_ci,IMPLICIT)…
  • Passing address of a variable by reference in C++
  • Left Outer Join using + sign in Oracle 11g
  • Is this request generated by EF Core buggy or is it my code?
  • "explode() expects parameter 2 to be string, object…
  • How do I update the quantity without duplicate in redux?
  • How can I get column names from a table in SQL Server?
  • Disable all table constraints in Oracle
  • Conversion failed when converting the varchar value…
  • Maximum size of a varchar(max) variable
  • DROP IF EXISTS VS DROP?
  • How to find column names for all tables in all…
  • Search All Fields In All Tables For A Specific Value…
  • How to make vuetify v-data-table vertically span all…
  • How to include a PHP variable inside a MySQL statement
  • error: strcpy was not declared in this scope
  • Why is conversion from string constant to 'char*'…
  • Generate SQL Create Scripts for existing tables with Query
  • Conversion of a varchar data type to a datetime data…
  • Setting equal heights for div's with jQuery
  • Converting Oracle SQL Procedure into MySQL Stored Procedure
  • How to implement a basic iterative pushdown…
  • How to get the in HTML tables to fit content, and…
  • How to return result of a SELECT inside a function…
  • Next.js making a timeout stop with a react state
  • I use useState hock to store the value but it did not update
  • What is causing ERROR: there is no unique constraint…
  • Creating a custom counter in Spark based on…
  • How to avoid the need of writing…
  • Subtracting Dates in Oracle - Number or Interval Datatype?
  • vuex - is it possible to directly change state, even…
  • Vuex update array as value of object
  • The localStorage is not refreshing in Vuex
  • Database development mistakes made by application developers
  • Remix error The transaction has been reverted to the…
  • Bind json data into two dependent dropdown list in…
  • AngularJS ui-router login authentication
  • Receive WebSockets data from vuex and…
  • Setting DEBUG = False causes 500 Error
  • How can I find the product GUID of an installed MSI setup?
  • The image I am adding as a button in Tkinter is not…
  • How to implement a FSM - Finite State Machine in Java

Disclaimer: This content is shared under creative common license cc-by-sa 3.0. It is generated from StackExchange Website Network.

Post navigation

Previous Post:

How can I update npm on Windows?

Next Post:

How do I remedy “The breakpoint will not currently be hit. No symbols have been loaded for this document.” warning?

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

.net ajax android angular arrays aurelia backbone.js bash c++ css dataframe ember-data ember.js excel git html ios java javascript jquery json laravel linux list mysql next.js node.js pandas php polymer polymer-1.0 python python-3.x r reactjs regex sql sql-server string svelte typescript vue-component vue.js vuejs2 vuetify.js

  • you shouldn’t need to use z-index
  • No column in target database, but getting “The schema update is terminating because data loss might occur”
  • Angular – expected call-signature: ‘changePassword’ to have a typedeftslint(typedef)
  • trying to implement NativeAdFactory imports deprecated method by default in flutter java project
  • What should I use to get an attribute out of my foreign table in Laravel?
© 2022 Fix Code Error