Home Forums SQL Server 2008 SQL Server 2008 - General Substring / Patindex for wildcard select RE: Substring / Patindex for wildcard select

  • January 17, 2014 at 9:27 am

    #1681131

    gwyn.jones (1/17/2014)

    Thanks 🙂

    I will try that case. Cannot use where as script is huge as it is with lots of unions and where clauses so just wanted a nice easy add on in the select!!

    Why is it giving output to fields that don't contain CED?!

    Because PATINDEX('%CED:%',comment) will return 0 if the field doesn't contain CED. With the CASE statement, you can't validate to use values only when PATINDEX('%CED:%',comment) > 0

    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