how to use like query

Accepted answer

string str_query = "SELECT * FROM dbo.Users AS u WHERE FirstName LIKE'" + text.text + "%'";

SELECT * FROM dbo.Users AS u WHERE FirstName LIKE 'r'+'%' here how to put textbox.text like '"+text.text+'%'"' i do like this it show error so please check it

Khan Abrar Ahmed12y ago

Hi use can use like this
SELECT * FROM dbo.Users AS u WHERE FirstName LIKE 'r'+'%'

Kedar Pawgi12y ago

Hi i am sending this query with respect to php, you will have to check for Asp syntex.

$courseSql = "select Name,address, city from city where name LIKE '%" . $sItem ."%' ";

here $sItem is the value passed from textbox for search in your case is "r",

Hope this solves your problem