how to use like query

Question

need to show the data that is fetch from sqlserver in a textbox i press r means i need to retrieve data from sqlserver raj rani ravi ragu i need like this

sudipta sanyal · Answer

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

selvi subramanian · Answer

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 Ahmed · Answer

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

kedar pawgi · Answer

Hi i am sending this query with respect to php you will have to check for Asp syntex. $courseSql = select Nameaddress 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