Home Dashboard Directory Help
Search

PATINDEX Missing ESCAPE Clause by Victor Lindsey


Status: 

Closed
 as Won't Fix Help for as Won't Fix


8
0
Sign in
to vote
Type: Suggestion
ID: 259534
Opened: 2/21/2007 8:13:18 PM
Access Restriction: Public
0
Workaround(s)
view

Description

Unlike the LIKE and NOT LIKE expressions, PATINDEX cannot use the ESCAPE clause to form complex pattern expressions that involve use of some reserved wildcard characters. For example "WHERE COL1 LIKE '%[()[\]{}<>]%' ESCAPE '\'" seems impossible to express within a PATINDEX function.
Details
Sign in to post a comment.
Posted by Stan Segers on 10/20/2008 at 8:27 AM
Extend the request to CHARINDEX too.
Posted by Microsoft on 5/30/2007 at 2:02 PM
Hi,
    Thanks for the feedback about PATINDEX functionality. We are in the process of looking through all possible enhancements for the future releases of SQL Server and we will conisder enhancing the PATINDEX to support escape clauses as part of these enhancements. Once again thanks for the feedback and it is very much appreciated.

-- srini acharya
Program Manager, Relational Engine
Sign in to post a workaround.