In SQL, in order to grab n characters from the left side of a string, you can use the LEFT function:
SELECT LEFT('Hello World', 5)
-- "Hello"
There doesn't appear to be a left or right function in the docs on scalar functions:
Q: How do you do select left most characters in KQL?