how to scan variable

• shiwani2002sg

  Ten Centuries

  Points: 1037

  More actions

  July 17, 2008 at 12:33 am

  #123782

  like in Oracle we use special character '&' infront of variable name like &name to scan the value of the variable, what is the same procedure in SQL server 2005. ie can i make a dynamic querry

• Vidhya Sagar

  SSCrazy Eights

  Points: 8216

  More actions

  July 17, 2008 at 4:33 am

  #844255

  [font="Verdana"]In SQL Server you need to use % symbol

  SELECT NAME from employee where name like '%kumar%'

  The above query will return all the names from employee table which has kumar in it.[/font]

  Regards..Vidhya Sagar
  SQL-Articles