SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software SAP ABAP Programming and HANA Database Tutorials
Development resources, articles, tutorials, code samples and tools and downloads for ASP.Net, SQL Server, R Script, Windows, Windows Phone, AWS, SAP HANA and ABAP, like SAP UI5, Screen Personas, etc.

Install SAP Free

SQLScript String Function Left in SAP HANA

SQLScript string function LEFT is a string function for programmers to get the first n characters from beginning of a given string value. SQLScript developers use string function Left to returns the first characters from the first character of a string.

Left() string function has two arguments; first input string, second is the number of characters to return from the beginning of the text variable.
Here is sample SQLScript code

do begin

declare v_url nvarchar(50) := 'SAP HANA SQLScript string function Left';
select left(v_url, 18) as First5Characters from dummy;

v_url := 'ŞĞÜİÇÖığçö';
 left(v_url, 5) as First5Characters,
 left(v_url, 10) as First10Characters,
 left(v_url, 20) as First20Characters
from dummy;


Here is the outputs of the Left string function in SQLScript executed on SQL Console

SQLScript String function Left

For SQLScript developers, official documentation on SQL string function Left can be viewed at SAP Help Portal

SAP Tutorials

SAP Tutorial

SAP Forums

SAP Tools

SAP Transaction Codes Table

Meetup Sunumu 1 meetup

Copyright © 2004 - 2020 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems