Check out our other answers here [ Ссылка ]

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link [ Ссылка ] to make a donation. Thanks for watching!

This video explains how to use placeholders and SQL string functions to highlight a set of characters in a table which match the value that a user has entered into a parameter. You'll learn about the replace, charindex, left, substring and len functions in SQL. You'll also see how to use multiple placeholders in a single textbox and apply different formatting to individual placeholders.

00:00 The Question
01:45 Creating a Query Parameter
03:22 Removing Wildcard Characters
05:28 Creating a Test Query in SSMS
07:18 Locating One String Within Another
09:00 Returning Characters from the Left of a String
10:35 Checking for Empty Strings
13:06 Extracting Characters from the Middle of a String
17:09 Getting Characters from the End of a String
19:44 Using the Query in Report Builder
21:05 Using Placeholders to Construct the Film Title
21:59 Formatting Placeholders

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more

свернуть