LEFT
Description
Sample Source Pattern
Syntax
LEFT ( character_expression , integer_expression ) LEFT ( <expr> , <length_expr> )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
SELECT LEFT('John Smith', 5) AS FIRST_NAME FIRST_NAME|
----------+
John |SELECT RIGHT('John Smith', 5) AS LAST_NAME FIRST_NAME|
----------+
John |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;FIRST_NAME|
----------+
John |Last updated
Was this helpful?