js-sql-parser icon indicating copy to clipboard operation
js-sql-parser copied to clipboard

Published 20 hours ago • verified publisher icon JavaScriptor

Added support for LEFT and RIGHT functions

Open KNaved opened this issue 3 years ago • 1 comments

Added support for the below functions

SELECT LEFT('SQL Tutorial', 3) AS ExtractString;
SELECT RIGHT('SQL Tutorial', 3) AS ExtractString;

Earlier the parser was breaking as LEFT and RIGHT keywords were treated as part of joins only.

KNaved avatar May 11 '21 22:05 KNaved

any test case ?

albin3 avatar May 12 '21 06:05 albin3