Post reply

how to escape % when doing Like filter?

  • March 25, 2014 at 12:40 pm

    #305643

    Sorry no DDL, but can some one still offer help with syntax. I just need to have result where the field countername begins with a % (as percent) character. The below returns everything having word 'usage', 'idle', 'processor' , thereby returning more rows than I need.

    How to modify this so SQL knows I'm looking only for values starting with %?

    where countername like '%usage%'

    or countername like '%idle%'

    or countername like '%processor%'

  • March 25, 2014 at 12:50 pm

    #1700029

    Something like this?

    where countername like '[%]usage%'

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • March 25, 2014 at 12:52 pm

    #1700030

    this what worked

    where countername like '%[%]%usage%'

    or countername like '%[%]%idle%'

    or countername like '%[%]%processor%'

  • March 25, 2014 at 12:59 pm

    #1700032

    That will return all countername values containing a percentage sign before the word, not only the ones that start with the percentage sign.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply