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.
    • 已移動 Naomi NModerator 2012年5月18日 上午 01:08 T-SQL question (From:SQL Server Samples and Community Projects)
    2012年3月29日 下午 08:13