|
|
Posted by Martin Lukasik on 04/24/06 19:04
"Tony Rogerson" <tonyrogerson@sqlserverfaq.com> wrote in message
news:e2isig$2qt$1$8300dec7@news.demon.co.uk...
> where ( account like 'EB%
> or account like 'NB%' )
> and ( account like 'E0%
> or account like 'N0%' )
> and len( account ) between 6 and 7
Thank you,
Is there any easier way?
What if first characters are A, D, C, 4, X, Z, Y? It's not really nice to
type every permutation.
There must be some regular expression...
Martin
Navigation:
[Reply to this message]
|