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))

INSERTINTO@T(charc)

VALUES(‘Cat’)

,(‘hat’)

,(‘that’)

,(‘at’)

,(‘c’)

,(‘a’)

 

 

Percent % :

Underscore _ :

Square Brackets [] :

Caret:

 

 

 

 

 

 

 

Advertisements

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:

WordPress.com Logo

You are commenting using your WordPress.com 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