Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » UltraLite - Database Management and Reference » UltraLite SQL Reference » UltraLite SQL functions » SQL functions (E-O)

 

LEFT function [String]

Returns multiple characters from the beginning of a string.

Syntax
LEFT( string-expression, integer-expression )
Parameters
  • string-expression   The string.

  • integer-expression   The number of characters to return.

Returns

LONG VARCHAR

LONG NVARCHAR

Remarks

If the string contains multibyte characters, and the proper collation is being used, the number of bytes returned may be greater than the specified number of characters.

You can specify an integer-expression that is larger than the value in the argument string expression. In this case, the entire value is returned.

Whenever possible, if the input string uses character length semantics the return value will be described in terms of character length semantics.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.

Example

The following statement returns the first 5 characters of each Surname value in the Customers table.

SELECT LEFT( Surname, 5) FROM Customers;