Substring Function SQL Server
Published on Sep 04, 2017:
In this video tutorial, we will learn to get the subset of a string using the substring function.
Documentation for the substring function can be found at the below location:
https://goo.gl/fd3bw2
SQL used in the example is copied below.
Select 'Hello World!!!' HelloWorld
Select Substring('Hello World!!!!!',6,11) HelloWorldSubset
SELECT
[EnglishMonthName]
,Substring(EnglishMonthName,1,3) MonthShortName
,[MonthNumberOfYear]
,[CalendarQuarter]
,[CalendarYear]
,[CalendarSemester]
,[FiscalQuarter]
,[FiscalYear]
,[FiscalSemester]
FROM [AdventureWorksDW2012].[dbo].[DimDate]
Previous Video: • Convert number to a string
SUBSCRIBE to learn more about Power BI,Power Query, Power Pivot, Excel and SQL Server!
/ @learnexcelrelentless
Download the sample database used for the demo here: https://goo.gl/SVyVmT
Our Playists:
SQL Playlist :https://goo.gl/PS5Ep6
DAX PlayList : https://goo.gl/S4W41D
Power BI PlayList: https://goo.gl/dXxvnB
Power Query Playlist: https://goo.gl/5QS7P4
ABOUT DAGDOO:
Website:
Home Page: http://www.dagdoo.org/
Power BI Tutorials: http://www.dagdoo.org/excel-learning/...
Questions? Comments and SUGESTIONS? You will find me here:
Twitter: @dagdooe
Category: Science & Technology
License: Standard YouTube License
On this page of the site you can watch the video online Substring Function SQL Server with a duration of hours minute second in good quality, which was uploaded by the user Learn 2 Excel 04 September 2017, share the link with friends and acquaintances, this video has already been watched 1,142 times on youtube and it was liked by 4 viewers. Enjoy your viewing!
