HOW TO USE WILDCARD CHARACTERS IN LIKE OPERATIONS?

Amit Singh

Total Post:565

Points:2825
Posted by  Amit Singh
 1007  View(s)
Ratings:
Rate this:
  1. Amit Singh

    Post:565

    Points:2825
    How To Use Wildcard Characters in LIKE Operations?

    Wildcard character '%' can be used in the pattern string for the LIKE operator to match any string of zero or more characters.

    for example:

    SELECT c.CompName FROM Company c
    WHERE c.CompName LIKE '%Mind% Stick'

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!