-
User NOT LIKE (alpha)
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
-
Something like:
where substring(user.name, 1, 1) not in (.....)
-
WHERE users.name LIKE '[^A-Z]%'
-
WHERE users.name LIKE '[^A-Z]%'
Or
users.name NOT LIKE '[A-Z]%' ?
thank you
-
If you have database with case insesitivity then both of them are same.
-
They should be same in case sensitive db too.
-
-
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.
-
the database is not but it is good to know
thank you skhanal
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|