We discuss SQL WildCards and practically go through the four different wildcard symbols to retrieve data with the AdventureWorks2019 Database in SQL Server 2019. We see how to use the "%", "[ ]", "^ or !", and the "_" symbols in SQL Server.
-LINK TO SQL QUERY-
https://github.com/AllThingsDataWithA...
-LINKS TO PLAYLISTS-
Learn SQL with Microsoft SQL Server: • SQL
Data Analyst Portfolio Projects: • Data Analyst Portfolio
HAPPY WITH THE CONTENT?
SUBSCRIBE NOW! CLICK HERE - / @angelinafrimpong
OR HERE - https://bit.ly/angelinafrimpong
Timestamps:
00:00 Intro
00:55 Different WildCard Symbols
03:07 Using Percent (%) WildCard Symbol
06:17 Using Square Bracket ([ ]) WildCard Symbol
08:47 Using Caret (^) or Exclamation (!) WildCard Symbol
11:31 Using Underscore (_) WildCard Symbol
15:48 ESCAPE clause
18:09 Questions to try
19:07 Outro
#SQL #LearnSQL #Data
On this page of the site you can watch the video online Learn SQL with Microsoft SQL Server | SQL WildCards | Part 7 with a duration of hours minute second in good quality, which was uploaded by the user Angelina Frimpong 10 March 2022, share the link with friends and acquaintances, this video has already been watched 709 times on youtube and it was liked by 38 viewers. Enjoy your viewing!