Senator Guerra Souty original series calendar,replica hublot blue steel peach pointer collocation of rolex replica Rome digital scale, track type minute replica watches scale shows that the classical model is swiss replica watches incomparable, wearing elegant dress highlights.
mr-ponna.com

 

YOU ARE HERE: HOME Questions How to check multiple LIKE conditions in one single SQL Statement

Checking multiple LIKE conditions in SQL Statement

 View(s): 20873

How to check multiple LIKE conditions in one single SQL Statement.

Answer 1)

There is no direct way to achieve this functionality. But possible if you could get Regular expression support in your SQL Server.

Following 2 articles to guide you to get RegEx support in your SQL Server: 
  1. VBScript.RegExpRegular Expressions in T-SQL using VBScript.RegExp
    For this solution we need SQL Server 2000 or higher. Also we need to make sure we have the VBScript.RegExp library on our computer.
  2. Regular Expressions in T-SQL using CLR User-Defined Functions
    This solution works with SQL Server 2005 or higher
  Asked in:  Broadridge   Expertise Level:  Experienced
  Last updated on Wednesday, 03 April 2013
2/5 stars (3 vote(s))

Register Login Ask Us Write to Us Help