Welcome to PC Teach Me...

Free Computer Training Videos.

Although you do not need to register to access this site. Registering has its benefits. Such as:

  • Access to training material associated with the video you are watching [if applicable]
  • Automatic email updates when new training videos are available.
  • Ask for a training video.
  • Exclusive access to pose questions to me [limited availability as I am doing this for free :-)].
  • Free contribution of your own training topics, this includes referencing your videos outside of PC Teach Me.
  • Its Free!

Member Login

Lost your password?

Not a member yet? Sign Up!

By registering with this blog you are also agreeing to receive email notifications for new posts but you can unsubscribe at anytime.

25425 Registered Users
71 Number Of Articles
Free Video Tutorials (Email) Free Video Tutorials (RSS) Free Video Tutorials (Twitter) Free Video Tutorials (Flickr)

SQL: Like Statement Special Wildcards

Part of Microsoft SQL Intermediate

sql SQL: Like Statement Special Wildcards SQL: Like statement with advanced wildcards

From time to time you will want to search within your database for specific information. Quite often this information would be a name or descriptor of some shape or form, but what if you want to search on a symbol?

SQL Wildcards within the like statement

More specifically a symbol that is also used as a wild-card.  Let me give you an example, what if you had a text value of “75%” and you wanted to search on all records that have the “%” symbol within the text your searching for?

You may think this is a non issue, but trust me it is becuase the “%” is your primary wildcard for searching for anything within the text, now you have a problem as the very symbol you use to to search with is now the symbol you want to search on!

A lot of people have pulled their hair out on that one because as soon as you use the “%” percentage symbol or “_” underscore symbol your stumped due to them being reserved symbols for the like clause.

Well worry no further, this video will explain the way to tell that pesky symbols to be a symbols to search on rather than symbols for searching with.

Other SQL Videos

This video is one of many SQL tutorials on this site click here for more

Related Posts

28 Comments

  1. Tomas Žvinys says
    07 Jun 15 at 4:36am

    Perfect:) I like short concentrated videos!

  2. qYp88 says
    26 May 11 at 6:22am

    you should get a better mic, the hissing from the s and c is getting tiresome after a while, otherwise nice lessons !

  3. qYp88 says
    26 May 11 at 6:22am

    [..YouTube..] you should get a better mic, the hissing from the s and c is getting tiresome after a while, otherwise nice lessons !

  4. qYp88 says
    26 May 11 at 6:22am

    you should get a better mic, the hissing from the s and c is getting tiresome after a while, otherwise nice lessons !

  5. qYp88 says
    26 May 11 at 6:22am

    you should get a better mic, the hissing from the s and c is getting tiresome after a while, otherwise nice lessons !

  6. qYp88 says
    26 May 11 at 6:22am

    you should get a better mic, the hissing from the s and c is getting tiresome after a while, otherwise nice lessons !

  7. qYp88 says
    26 May 11 at 6:22am

    you should get a better mic, the hissing from the s and c is getting tiresome after a while, otherwise nice lessons !

  8. qYp88 says
    26 May 11 at 6:22am

    you should get a better mic, the hissing from the s and c is getting tiresome after a while, otherwise nice lessons !

Leave a Comment

You must be logged in to post a comment.

Valid XHTML 1.0 Transitional website security