Table of ContentsPreviousNext

Ispirer             Ispirer


Ispirer SQLWays Database Migration Software

LEFT

Syntax

LEFT(char_expr, int_expr)

LEFT returns int_expr leftmost characters of char_expr.

Example

This example returns the five leftmost characters of each book title.

SELECT LEFT(title, 5) 
FROM titles 
Here is the result set: 
__________________ 
The B 
Cooki 
You C 
The G 
The P  

Equivalents in other databases

TABLE 93. Equivalents in other databases
IBM DB2
LEFT function
Oracle
SUBSTR function


Table of ContentsPreviousNext
Ispirer             Ispirer
Copyright © 1999-2015 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.