"Group By" trim and case issues
Posted: 2005-11-14 19:35:37
Hi,
I grouped my catalogue by directors and find some minor issues :
- when the same name has different capitalization (ex : "John DOE" and "John Doe")
- when the same director name is finished with a blank (ex: "John Doe" and "John Doe ")
the same director names are grouped in two different places.
Is it possible to upper/lowercase and trim the director name before sorting the movies ?
TIA
I grouped my catalogue by directors and find some minor issues :
- when the same name has different capitalization (ex : "John DOE" and "John Doe")
- when the same director name is finished with a blank (ex: "John Doe" and "John Doe ")
the same director names are grouped in two different places.
Is it possible to upper/lowercase and trim the director name before sorting the movies ?
TIA