How to crea5e procedure???

• raghuldrag

  Hall of Fame

  Points: 3160

  More actions

  February 6, 2013 at 2:07 am

  #270491

  I'm creating one table ps(phonenumber search)

  create table ps

  (

  name varchar(100),

  email varchar(100),

  mobile varchar(100),

  address varchar(100)

  )

  insert into (name,email,mobile,address) values('ra', email@removed ''1234567890''chennai');

  like I'm inserted 20 name in 'r'

  I want to create one procedure.for expecting o/p:

  (select name from ps where name like 'r%')

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  February 6, 2013 at 2:11 am

  #1584792

  CREATE PROCEDURE ... (@param1 char(1))

  AS

  SELECT name FROM ps WHERE LEFT(Name,1) = @param1