Welcome to Sign in | Help

Re: Wild cards in patindex

  •  01-29-2011, 3:39 PM

    Re: Wild cards in patindex

    PATINDEX('%[^a-z]'+@q+'[^a-z]%',@Text)
    Rectificare:
    PATINDEX('%[^a-z]'+@q+'[^a-z]%',@Text) > 0
    OR PATINDEX(@q+'[^a-z]%',@Text)  > 0
    OR PATINDEX('%[^a-z]'+@q',@Text) > 0
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems