"GMG" <nospam@nospam> wrote in message
news:%23GLSksTGHHA.4804@TK2MSFTNGP03.phx.gbl...
> Basically, I have found that .. and - give different results in a
> character
> range comparison.
>
> [A-Z] will behave differently to [A..Z]
>
> See article below:
>
> http://www.mssql.com.au/kb/html/gmgxsl.dll/htmlkb?usexsl=y&sp=psearch_articl
> e_text&@sa_id=66
>
>
>
>
>

"Tom Cooper" <tomcooper@comcast.no.spam.please.net> wrote in message
news:t8CdnQZZdJRtZevYnZ2dnUVZ_oqdnZ2d@comcast.com...
> In SQL, character ranges must be done with -, not .. [A..Z] is the same
> kind of thing as [ABC], just a list of allowed choices. So only 'A', 'Z',
> and '.' match [A..Z].
>
> Try
>
> Select
> Case When 'A' Like '[A..Z]' Then 'A Yes' Else 'A No' End,
> Case When 'B' Like '[A..Z]' Then 'B Yes' Else 'B No' End,
> Case When '.' Like '[A..Z]' Then '. Yes' Else '. No' End
>
> to demonstrate this.
> Tom
>
> "GMG" <nospam@nospam> wrote in message
> news:%23GLSksTGHHA.4804@TK2MSFTNGP03.phx.gbl...
> > Basically, I have found that .. and - give different results in a
> > character
> > range comparison.
> >
> > [A-Z] will behave differently to [A..Z]
> >
> > See article below:
> >
> >
http://www.mssql.com.au/kb/html/gmgxsl.dll/htmlkb?usexsl=y&sp=psearch_articl
> > e_text&@sa_id=66
> >
> >
> >
> >
> >
>
>