Cool Using Like In Sql References

Cool Using Like In Sql References. If any one of the arguments isn't of character string data type, the sql server database engine converts it to character string data type, if it's possible. You will learn more about wildcards in the next chapter.

SQL LIKE Operator and Wildcards from www.tutorialgateway.org

Select * from table where name like '%' + search_criteria + '%' if search_criteria ='abc', it will return data containing xxxabcxxxx which is fine. Select * from tablename where column in ('m510%', 'm615%', 'm515%', 'm612%'); Web select [ column_list | * ] from table_name where column or expression like pattern;