top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

Can someone please explain working of RIGHT and LEFT functions working in SQL Server?

+2 votes
70 views
Can someone please explain working of RIGHT and LEFT functions working in SQL Server?
posted Oct 18, 2013 by Atul Mishra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+4 votes
 
Best answer

In SQL Server Right or Left is used to select a particular portion of a string, either from right side of it or from Left side. See an example below-

SELECT LEFT('HELLO WORLD', 3) Result- HEL

SELECT RIGHT('HELLO WORLD', 3) Result- RLD

Instead of these 2 we can use substring() also, it has few additional feature as well.

answer Nov 14, 2013 by Neeraj Pandey
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...