How to check a parameter for #

• .Netter

  SSCrazy

  Points: 2476

  More actions

  April 20, 2012 at 5:21 am

  #259863

  Hi Guys,

  I have a procedure which inserts a record into table but i want to check the parameters before if the insert if they contain # then dont update else update

  this is my procedure i want to condition it with an if statement

  if @Column1 contains # or @column2 contains # or @column3 contains # then dont do insert?

  Can someone help me please.

  INSERT INTO Generis.dbo.CustomerBankDetails

  (UID ,Column1,column2,Column3)

  VALUES

  (@Uid ,@column1,@column2,@column3)

• April 20, 2012 at 6:11 am

  This was removed by the editor as SPAM

• .Netter

  SSCrazy

  Points: 2476

  More actions

  April 20, 2012 at 7:06 am

  #1476603

  See i was thinking more towards a charindex but your snippet works perfectly.

  Thank you 😀

• April 20, 2012 at 7:34 am

  This was removed by the editor as SPAM