User can check whether the String is there with using PL SQL Building blocks as well. Solution 4 : In PL SQL Building Block Or T-SQL block The above query will fetch the customer data where First_name Contains string as вЂAmitвЂ™ Select * from Customer where CONTAINS(First_name,вЂ™AmitвЂ™) So it is always recommended to use the Contains function to check the patterns. The contains function is faster than LIKE operator. In MS SQL we have the Contains function as well. Solution 3 : Microsoft SQL Server Solution : Select * from Customer where First_Name IN (вЂAmitвЂ™) The same query user can write using IN operator. The above query will fetch the data from Customer table where First_Name contains String as вЂAmitвЂ™. Select * from Customer Where First_name LIKE вЂ%Amit%вЂ™ SQL Query Logic : Here user needs to use like operator to check whether there are people whose name contains вЂAmitвЂ™. Scenario 1 : If user wants to Find out the customers Whose name contains вЂAmitвЂ™. I would like to start with simple examples of SQL Contains String, I would like to start with simple LIKE Operator examples.The Like operator is most commonly used operator for pattern matching in SQL. In this section i want to give you multiple real life examples of SQL Contains. There is always question in mind about the SQL Contains Strings and how to use the SQL Contains String ? In this article i would like to give you pattern matching techniques for SQL which i have already covered in historical articles.In this article i would like to give you multiple examples of SQL Contains String. In my previous article i have given the details about different SQL statements with real life examples.

Mapinfo 10 how to create rings