Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
KnooKie
Aged Yak Warrior
623 Posts |
 Posted - 2002-01-14 : 07:41:43
|
| Is there a way to write a SQL statement that will select only names from a list whose first letter begins with a lower case letter ?Any ideas much apprepciatedPaul |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-01-14 : 07:54:00
|
| SELECT * FROM TABLEWHERE ASCII(SUBSTRING(NAME,1,1))=ASCII(SUBSTRING(LOWER(NAME),1,1)) HTH----------------------------------"True love stories don't have endings."Edited by - Nazim on 01/14/2002 08:42:05 |
 |
|
|
|
|
|
SELECTing LOWER case only