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
En esta página del sitio puede ver el video en línea Substring Function SQL Server de Duración hora minuto segunda en buena calidad , que subió el usuario Learn 2 Excel 04 septiembre 2017, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 1,142 veces y le gustó 4 a los espectadores. Disfruta viendo!
