Reference Guide
>
TDV Support for SQL Functions
>
Character Functions
>
LEFT
LEFT
This function is used to extract a number of characters from a string (starting from left).
Syntax
LEFT(string, number of characters)
Example
SELECT LEFT(‘Tibco Data Virtualization’, 5)
Returns: Tibco