By Andrew Gould
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
Chapters
00:00 Topic List
00:43 The Basic Report
03:30 Basic Concatenation
07:06 Concatenation in SQL
09:30 Concatenation with Placeholders
11:58 Concatenating Names
13:55 Dealing with Nulls
20:27 Concatenating Numbers
23:43 Concatenating Numbers in SQL
29:44 Formatting Numbers in a String
38:11 Formatting Numbers in SQL
40:23 Formatting Placeholders
42:26 Concatenating Tab Characters
46:13 Concatenating New Line Characters
https://www.wiseowl.co.uk - This video explains how to concatenate values to form longer strings of text. You'll learn how to join text field values to literal text in both Visual Basic and SQL. You'll also see how to concatenate numbers and dates with text and how to deal with Nulls. The last part of the video explains how to add special characters to your strings using both the ASCII character codes and some Visual Basic constants.
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, VBA, Power BI, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more
