Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1924

Regular expression question

Show all headers | View raw

SQL Server 2005.  The second and third versions of the 
following statement print 'Yes', which is unexpected. 

The intention is to test whether the first term is 
a compound house "number" such as '1A' or '1-3'.
Either / or \ I thought would perform an "escape" 
in the pattern string, to treat a following special 
character as the literal character, but it seems to 
perform correctly without that, not with.  So this 
test may be not doing what I think it is, at all.
And the question is: uh?  ;-)

IF ( '15' LIKE N'[1-9]%[-A-Z]%'  ) PRINT 'Yes 1' 

IF ( '15' LIKE N'[1-9]%[/-A-Z]%' ) PRINT 'Yes 2'

IF ( '15' LIKE N'[1-9]%[\-A-Z]%' ) PRINT 'Yes 3' 

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

Regular expression question rja.carnegie@gmail.com - 2015-07-10 08:05 -0700
  Re: Regular expression question Erland Sommarskog <esquel@sommarskog.se> - 2015-07-10 21:54 +0200
    Re: Regular expression question rja.carnegie@gmail.com - 2015-07-18 08:59 -0700

csiph-web