User NOT LIKE (alpha)

[anselme]

Hi

for MS SQL 2000

I am searching users for each letter

WHERE users.name LIKE ('A%')

how can i search For users.name not starting by A to Z ? all except letters

thank you

[rmiao]

Something like:

where substring(user.name, 1, 1) not in (.....)

[skhanal]

WHERE users.name LIKE '[^A-Z]%'

[anselme]

WHERE users.name LIKE '[^A-Z]%'

Or

users.name NOT LIKE '[A-Z]%' ?

thank you

[skhanal]

If you have database with case insesitivity then both of them are same.

[rmiao]

They should be same in case sensitive db too.

[anselme]

thank you ...

[skhanal]

What I meant was

WHERE users.name LIKE '[^A-Z]%'

Or

users.name NOT LIKE '[A-Z]%' ?

are same but if the database is case sensitive then you will still get records with names in lower case.

[anselme]

the database is not but it is good to know
thank you skhanal