CHARINDEX with Text in Table


  • 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.
    • Movido Naomi NModerator sexta-feira, 18 de maio de 2012 01:08 T-SQL question (From:SQL Server Samples and Community Projects)
    quinta-feira, 29 de março de 2012 20:13

Todas as Respostas