using like with variable

• mazal0404

  Old Hand

  Points: 343

  More actions

  September 30, 2008 at 8:00 am

  #75328

  Hi everyone,

  "SELECT parentName FROM tblParent WHERE parentName

  LIKE '" + name + "' ";

  this is my query, but how can I use "like " when I want the query find the parentName even if i type part of the name or even one letter from the name?

  Thanks

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  September 30, 2008 at 9:10 am

  #878922

  SELECT

  parentName

  FROM

  tblParent

  WHERE

  parentName LIKE '%' + @name + '%'

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• mazal0404

  Old Hand

  Points: 343

  More actions

  September 30, 2008 at 5:55 pm

  #879252

  first thank you very much 🙂

  Im working with c#, so in my case this expression work for me:

  SELECT

  parentName

  FROM

  tblParent

  WHERE

  parentName LIKE '%" + name + "%'