• L' Eomot Inversé (11/30/2013)


    Well, the natural answer to that is that you can't use [] to match any character. [a] can match something, can, and [cde] can, and so on, but none of those were on your list

    But [a], , and [cde] are all wildcard patterns - a search pattern that combines wildcard characters and normal characters to define the set of strings that should match.

    The question was not about wildcard patters (or, to stick to the official Microsoft terminology, "like patterns"). The question was about wildcard characters. Of which exactly four are described in Books Online: %, _, [], and [^]. See http://technet.microsoft.com/en-us/library/ms179859.aspx.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/