SQL Server Performance

Using Like with %... How to ?

Discussion in 'SQL Server 2005 General Developer Questions' started by Mr.Mando, Jun 17, 2009.

  1. Mr.Mando New Member

    Hello,
    How can I use the % with stopred procedure ?
    I have a variable called @Keyword varchar(50)
    and I'm sending values from aspx page
    How can I add % before and after the value which coming from the page ?
    Thanks
    Mr.Mando, Jun 17, 2009
    #2

  2. Adriaan New Member

    Simple ...
    SET @Keyword = '%' + @Keyword + '%'
    Adriaan, Jun 17, 2009
    #3

  3. Mr.Mando New Member

    Thank you so much I just got it after I post the topic
    I'm still beginner and trying to selflearn SQL Server
    Thanks again
    Mr.Mando, Jun 17, 2009
    #4

Share This Page