What Operator performs Pattern Matching ?

Posted by Bharathi Cherukuri on 4/23/2012 | Category: Sql Server Interview questions | Views: 11388 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

Pattern matching operator is LIKE and it is used with two attributes:

1. % - means matching zero or more characters

2. _ ( underscore ) - means mathing exactly one character

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : How can i hide a particular table name of our sche ...

Next > : What is diffrence between Co-related sub query and ...

Comments or Responses

More Interview Questions by Bharathi Cherukuri

What is diffrence between Co-related sub query and nested sub query ?
What is the difference between SQL and SQL Server ?
What does the term immutable mean ?
In which cases you use override and new base ?
Can we call a base class method without creating instance ?
Can you inherit from multiple base classes in C# ?
What happens when you encounter a continue statement inside for loop ?
IS goto statement supported in C# ? How about Java ?

Latest Interview Questions

What is metadata?
Difference between Finalize() and Dispose()?
What is Identity?
Is there a way to decrypt stored procedure?
How to get the nth row value of a table.
How to get record of nth row of a table ?
What is sp_config command?
Which of the following attributes should you add to a class to enable ...
More ...