like sql

Please login or create account to add a snippet.

Follow @TagMyCode

Language: ASP

Posted by: Mario Lopes

Added: May 22, 2018 8:40 AM

Tags: concat like sql

s.SelectParameters.Clear();
s.SelectCommand = "select * from perfumes where routelink like CONCAT('%',?,'%')";
s.SelectParameters.Add("@a", txtPesquisa.Text);
s.DataBind();