you will ‘%_[^LIKE]%’ like

Like cluase allows you to match a character string found in a column to a specified pattern in the where clause

lets take an example to better understand its wild cards

How to use like in where clause

DECLARE@TTABLE (charcvarchar(20))










Percent % :

Underscore _ :

Square Brackets [] :










One thought on “you will ‘%_[^LIKE]%’ like

  1. google says:

    Having read this I believed it was really enlightening.
    I appreciate you spending some time and effort to put this information together.
    I once again find myself personally spending way too much time both reading and leaving comments.
    But so what, it was still worth it!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s