Returns the right part of a character string with the specified number of characters. ().
Sample Source Pattern
Syntax
LEFT ( character_expression , integer_expression )
LEFT ( <expr> , <length_expr> )
Function used to emulate the behavior
function LEFT(string, index){
if(index < 0){
throw new RangeError('Invalid INDEX on LEFT function');
}
return string.slice( 0, index);
}
return LEFT(STR, INDEX);
Examples
Code:
IN -> SQLServer_01.sql
SELECT LEFT('John Smith', 5) AS FIRST_NAME;
Output:
FIRST_NAME|
----------+
John |
Code:
OUT -> SQLServer_01.sql
SELECT LEFT('John Smith', 5) AS FIRST_NAME;
Output:
FIRST_NAME|
----------+
John |
Code:
CREATE OR REPLACE FUNCTION left_str(str varchar, index float)
RETURNS string
LANGUAGE JAVASCRIPT
AS
$$
function LEFT(string, index){
if(index < 0){
throw new RangeError('Invalid INDEX on LEFT function');
}
return string.slice( 0, index);
}
return LEFT(STR, INDEX);
$$;
SELECT LEFT_STR('John Smith', 5) AS FIRST_NAME;
