Passing string as parameter to stored procedures

• raveen4u

  SSC Veteran

  Points: 251

  More actions

  June 16, 2009 at 11:56 pm

  #205600

  Hi

  I am writing stored procedures in sql 2005 server. I want to pass string as parameter to retrieve the details. just like using 'LIKE' keyword in sql. I could pass integer.

  When I'm trying execute this its bland details are displayed. I'm executing directly db(not calling from application)

  Eg:

  Create SP_Emp

  @name varchar(50)

  Begin

  Select FName,LName FROM EmpDetails

  Where FName like '%ve%'

  End

• John H Marsh

  SSChampion

  Points: 11671

  More actions

  June 17, 2009 at 12:11 am

  #1010653

  Hello,

  If I understand your question correctly, you just need to include the parameter in your Where clause e.g.

  Where FName Like '%' + @name + '%'

  Regards,

  John Marsh

  www.sql.lu
  SQL Server Luxembourg User Group