Search record by name in sql server.

Question

In my user table i want to search users in dropdown then at the top of the dropdown all users display name is start from a and then others users which have alphabet a any position.How to create query in SQL SERVER?

Midhun T P · Answer

Hi Try below query - SELECT * FROM tablename WHERE name LIKE '%a%' ORDER BY name asc

Bikesh Srivastava · Answer

there are many method in asp.net c# I think you want search in dropdown then no need to change your sql query. firstly select all data and bind in dropdown and then use jquery to search item from dropdown according your typing word. otherwise you can use autocomplete textbox logic. visit here https://bikeshsrivastava.blogspot.in/2016/07/part-25how-to-implement-auto-complete.html

Ananth G · Answer

SELECT * FROM Customers WHERE Country LIKE '%a%' ; follow below url it me be help you http://www.w3schools.com/Sql/trysql.asp?filename=trysql_select_like_pattern