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 |
|
Dance Doll
Yak Posting Veteran
54 Posts |
 Posted - 2007-01-30 : 18:25:21
|
| When I created a group, it's give me different group even the data are same. Data is identical except case. For example: john & JOHN.The reporting services gives me two different group for this name.Please help!Thanks! |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-01-31 : 00:13:56
|
| Do aGROUP BY LOWER(FirstName)Peter LarssonHelsingborg, Sweden |
 |
|
|
Dance Doll
Yak Posting Veteran
54 Posts |
Posted - 2007-01-31 : 12:22:59
|
| Thanks! |
|
|
|
|
|
|
upcase & lowercase group