3rd highest salary in sql server

SQL Server substring

The SQL SUBSTRING() function is used to extract a sub string from a given string's start to end position.

Syntax:

//GET SQL SUBSTRING
SELECT SUBSTRING('C2495E17-2B72-4FA0-969D-BE8388E4BDBC', 5, 19) as SUBS_TRING_RESULT

OR

//GET SQL SUBSTRING
SELECT TOPUPPER(SUBSTRING (NAME,1,1)) + LOWER(SUBSTRING(NAME,2,255))
             AS 'CUSTOMER_NAME'
FROM CUSTOMER





ANIL SINGH

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Google Amazon and Flipkart Book Store!

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.
ASK Questions
SQL Server NodeJs TypeScript JavaScript Angular SQL Server My Book