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 |
|
velliraj
Yak Posting Veteran
59 Posts |
 Posted - 2009-09-17 : 04:30:47
|
| hi,i have table in my db.. contains column updated with names.i need to find the names updated with upper case letter.please let me know the function to find this.. |
|
|
sanoj_av
Posting Yak Master
118 Posts |
Posted - 2009-09-17 : 04:43:21
|
| You have to use a case Sensitive collation for the table. Then you can use a SQL condition like " Where column1=UCASE(column1)" |
 |
|
|
smarty
Starting Member
13 Posts |
Posted - 2009-09-17 : 05:22:26
|
| You can change the collation on the fly in your query; example belowSELECT Col FROM [YourTable] WHERE Col Latin1_General_CS_AI = [Case sensitive search]To get a list of collations use the code belowSELECT * FROM fn_helpcollations()Free SQL server monitoring for DBA'swww.realsmartsoftware.co.uk |
|
|
|
|
|
|
Find upper case letters