Home Forums SQL Server 7,2000 T-SQL How to use PATINDEX with a variable containing '[' and ']' RE: How to use PATINDEX with a variable containing '[' and ']'

  • February 20, 2014 at 10:18 am

    #1690797

    Is the bold part an error on your post or on your query?

    SELECT PATINDEX('%[[]' + @filename + '][]%',@FILEPATH)

    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