I have a base table called DEX, with fields "clname+','+cfname" all in upper case. . .I built a self referential DEXSPOUSE view and use it in a dropdown combo box to choose, sorted by "clname" ascending updateable. . .my drop list showed mixed upper and proper so I set to upper. . .it now shows fine but the sort is discombobulated sorting the upper first and then proper even though the base table is all upper. Any feedback on what I am doing wrong? Thx Bill
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Upper/Proper etc.
- Thread starter SMCmtg
- Start date
- Status
Similar threads
- Locked
- Question
