Convert INT to VARCHAR SQL
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…
- What are access specifiers? Should I inherit with…
- How do SO_REUSEADDR and SO_REUSEPORT differ?
- How to filter a RecyclerView with a SearchView
- Callback functions in C++
- 3 column layout HTML/CSS
- How do I obtain a Query Execution Plan in SQL Server?
- How to query for Xml values and attributes from…
- Using StringWriter for XML Serialization
- Should MySQL have its timezone set to UTC?
- SQL NVARCHAR and VARCHAR Limits
- How to access this variable from my store / state in…
- ReactJs : Nested State Not getting Updated
- T-SQL: Export to new Excel file
- no match for ‘operator
- What's the difference between eval, exec, and compile?
- Add pagination params to axios in Vue
- TypeScript metadata reflection references other…
- Change column type in pandas
- Design DFA accepting binary strings divisible by a…
- Best practices for SQL varchar column length
- How do I set initial state in Vuex 2?
- How to check if a table exists in a given schema
- Find and replace entire mysql database
- How to take backup of a single table in a MySQL database?
- How do I get the Back Button to work with an…
- data.table vs dplyr: can one do something well the…
- VueJS Dynamic Model Binding
- How to place object files in separate subdirectory
- Simulating group_concat MySQL function in Microsoft…
- What is a NullReferenceException, and how do I fix it?
- Ukkonen's suffix tree algorithm in plain English
- Search for a string in all tables, rows and columns of a DB
- Setting equal heights for div's with jQuery
- Is this request generated by EF Core buggy or is it my code?
- How to get the in HTML tables to fit content, and…
- vuex- state returned as function or object literal
- Left Outer Join using + sign in Oracle 11g
- vue watch mapState not working
- NextJS - can't identify where state change is…
- How to use Servlets and Ajax?
- My submit button is not getting enabled . How do i do that?
- Programmatically Lighten or Darken a hex color (or…
- Illegal mix of collations (utf8_unicode_ci,IMPLICIT)…
- "explode() expects parameter 2 to be string, object…
- Disable all table constraints in Oracle
- How to generate a random string of a fixed length in Go?
- Passing address of a variable by reference in C++
- DROP IF EXISTS VS DROP?
- How to return result of a SELECT inside a function…
- How do I update the quantity without duplicate in redux?
- For-each over an array in JavaScript
- Search All Fields In All Tables For A Specific Value…
- No function matches the given name and argument types
- Examples of GoF Design Patterns in Java's core libraries
- What are the undocumented features and limitations…
- How do I return the response from an asynchronous call?
- error: strcpy was not declared in this scope
- Why is conversion from string constant to 'char*'…
- How to implement a basic iterative pushdown…
- Maximum size of a varchar(max) variable
- How to paste yanked text into the Vim command line
- Conversion failed when converting the varchar value…
- Filter Vuex state
- What is causing ERROR: there is no unique constraint…
- vuex - is it possible to directly change state, even…
- How can I find the product GUID of an installed MSI setup?
- Generate SQL Create Scripts for existing tables with Query
- Setting DEBUG = False causes 500 Error
- How to include a PHP variable inside a MySQL statement
- How to find column names for all tables in all…
- Vue v-if and remove span
- Conversion of a varchar data type to a datetime data…
- How can I get column names from a table in SQL Server?
- AngularJS ui-router login authentication
- Database development mistakes made by application developers
- How to make vuetify v-data-table vertically span all…
- MySQL error: key specification without a key length
- How to avoid the need of writing…
- Vuex update array as value of object
- What is an IndexOutOfRangeException /…
- Why does C++ code for testing the Collatz conjecture…
- What is Ember RunLoop and how does it work?
- How to turn off ALL conventions in Entity Framework Core 5
- bind data to vue model dynamically in component
- Receive WebSockets data from vuex and…
- Subtracting Dates in Oracle - Number or Interval Datatype?
- Rails: How can I rename a database column in a Ruby…
- Difference between VARCHAR and TEXT in MySQL
- What are the new features in C++17?
- SQL Server: Query fast, but slow from procedure
- Is the term "format specifier" a synonym for term…
- Rename a column in MySQL
- javax.faces.application.ViewExpiredException: View…
- What is your most productive shortcut with Vim?
Disclaimer: This content is shared under creative common license cc-by-sa 3.0. It is generated from StackExchange Website Network.
