how to match the textbox value to the value in table
hai,
i have one doubt in .net in textbox i specify the text seperated by commas (eg: .net,sql)likewise.in sql table i registered one name for that name i specified (.net,sql,java,j2ee) in keyskill field .In .net i retrieve the name by using where condition
select * from regsiter where keyskill='"+TextBox1.Text+"'
when i execute this query i want to retrieve the row which text is given in textbox should match the data in sql(not accurately);
simply if i entered .net,sql in a textbox
i retrieve which row has .net,sql or any other like java,j2ee but .net is must.
how can i perform this
Thank u