answersLogoWhite

0

In MS SQL, you can use the char() operator on the column. For example:

select 'some string content ' + char(integer_field)

from my_table

User Avatar

Wiki User

17y ago

What else can I help you with?

Related Questions

How do you define an integer in SQL Server?

with the keyword int: eg: declare @myIntegerVariable int


What is var char in php?

Varchar in SQL means string in PHP.


What symbol is used to qualify column names in sql?

(.) Period


Under a column how many bytes for a TITLE in SQL Datrabase?

1 byte


How do you copy column heading in oracle sql developer?

Shift + cntrl + c


What does the SQL Max function do?

The "SQL Max function" is a computer programming term, which can be used in spreadsheets to give the highest value from the currently selected column.


What are the Defaults in Sql?

When you create a table, you can specify a DEFAULT value for each column which will be applied in the absence of an explicit value. For example; create table MYTABLE ( ID int, NAME varchar(40), TYPE int NULL DEFAULT 0) go insert into MYTABLE (ID, NAME) values (1,'record one') Although a value hasn't been provided for the column TYPE, the insert will create a record with a value of '0'.


Can you explain the process of how to properly drop a column in a database table using SQL?

To drop a column in a database table using SQL, you need to use the ALTER TABLE statement with the DROP COLUMN clause followed by the name of the column you want to remove. This action permanently deletes the specified column from the table, so make sure to back up your data before executing the command.


Feature of rdbms?

It stores data in tables. Tables have rows and column. These tables are created using SQL. And data from these tables are also retrieved using SQL


How do you create a table in Microsoft SQL?

create table tb (id int primary key, name varchar(10) not null, age int) tb - name of the table


What purpose does SQL inserts serve?

The purpose of a SQL inserts serve as allowing you to add data, for example a chart or a column afterwards. It works to hold the place for potential future data information.


What is single row subquery in sql?

a single row subqury is a query which will return a single row and single column