find correct string in column

• christophe.bernard 47659

  Ten Centuries

  Points: 1169

  More actions

  December 8, 2010 at 2:06 am

  #230173

  Hi,

  i'm a beginner with t sql and i have a table as this :

  tableBuilding

  (idBuilding int, nameBuilding, typeBuilding)

  I must to create a web service

  This web service must be receive one parameter as a string

  the method t sql must be ask at the tableBuilding give me all rows correspondiing with this string ..

  not complicate but here is it my solution but i wonder if it 's correct

  declare @building varchar(max)

  set @building = 'batiment 1'

  SELECT idBuilding, nameBuilding, typeBuilding where namebuilding = @building

  i've think to use like '%' + @building + '%' but if i type the CORRECT nameBuilding as parameter no rows as returned !!!!

  do you think my solution is correct ?

  i'm a beginner 🙂

  thanks for your time

• VSSGeorge

  SSCrazy Eights

  Points: 8151

  More actions

  December 8, 2010 at 2:27 am

  #1259949

  Hi

  Just try '%@building%'

• VSSGeorge

  SSCrazy Eights

  Points: 8151

  More actions

  December 8, 2010 at 2:34 am

  #1259954

  Else, go through these links

  http://www.codeproject.com/KB/database/SQL_LIKE_Operator.aspx

  http://www.codeproject.com/KB/database/SqlRegularExpressions.aspx

• christophe.bernard 47659

  Ten Centuries

  Points: 1169

  More actions

  December 10, 2010 at 6:41 am

  #1261009

  hi all,

  thanks for your comment, time and sample

  i've done this task.

  have a nice week end

  christophe