Interview Question, MS SQL, MS SQL

How to get first 5 letter without using Substring, Left and right in MS SQL Server

By using Stuff we can get the required value from the string.

SELECT STUFF('Prabhakaran Jayaraman', 6, LEN('Prabhakaran Jayaraman'), '')

Thank You

Leave a Reply

Prabhakaran Jayaraman