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.