SQL wildcard

Question

What is SQL wildcard?I am not familiar with it.

Satyapriya Nayak · Answer

Hi Akash, Please refer our recommended article Wildcards in SQL Server 2005 http://www.c-sharpcorner.com/uploadfile/karthikarajamma/wildcards-in-sql-server-2005/default.aspx Thanks

Priya Linge · Answer

Hi, 1. SQL wildcards can be used when searching for data in a database. 2.SQL wildcards can substitute for one or more characters when searching for data in a database. SQL wildcards must be used with the SQL LIKE operator. WildCard % : A substitute for zero or more characters _ : A substitute for exactly one character [charlist] :Any single character in charlist [^charlist] or :Any single character not in charlist [!charlist] 3.Example : we want to select the persons living in a city that starts with "sa" from the "Persons" table. SELECT * FROM Persons WHERE City LIKE 'sa%' we want to select the persons living in a city that contains the pattern "nes" from the "Persons" table. SELECT * FROM Persons WHERE City LIKE '%nes%' we want to select the persons with a first name that starts with any character, followed by "la" from the "Persons" table. SELECT * FROM Persons WHERE FirstName LIKE '_la' For more information please check below link, http://www.w3schools.com/sql/sql_wildcards.asp http://www.roseindia.net/sql/SQL_Wildcards.shtml Hope this will help you. Thanks.

SQL wildcard

Answers (2)