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:45 am

    #1690802

    This will return the correct results but only if you change your filename data type to varchar:

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

    This should show you the difference

    DECLARE @filename varCHAR(64)

    SET @filename = 'ASTERIX [Converted].eps.ai'

    SELECT '%' + @filename + '%'

    GO

    DECLARE @filename CHAR(64)

    SET @filename = 'ASTERIX [Converted].eps.ai'

    SELECT '%' + @filename + '%'

    GO

    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