none
CHARINDEX with Text in Table

    Dotaz

  • I need to check if any one of a table of text values are in a string. Is there a way to do this with one select statement and charindex or is there anothedr way? What I'm doing is checking for bot strings in a given user agent and setting a value in a table based on the result. I have a table of bots but I can't use a single charindex to check the user agent. I don't want to hard code multiple charindexes as the list of bots changes.
    • Přesunutý Naomi NModerator 18. května 2012 1:08 T-SQL question (From:SQL Server Samples and Community Projects)
    29. března 2012 20:13

Všechny reakce