SQL 2008 Char Function

In this article i will explain how to use char function in SQL..
  • 2814

Introduction

It is one of the string function. Char function returns the character for each integer passed.

Note-  Integer must be from 0 through 255. If integer is out of range then NULL is returned.

Syntax

Char (integer_expression)

where integer_expression is an integer, whose character function to be returned.

Example

Return character for integer passed.

Char-function-in-sql.jpg

Return NULL if integer is out of range.

Char-StringFunction-in-sql.jpg

Return character for numbers 0 to 255

CharFunction-in-sql.jpg

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.