What DB? In SQL Server there is no trim() you have to do lTrim(rTrim(yourColumn)) Unless you set up a custom function?
Tim > -----Original Message----- > From: Angel Stewart [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 03, 2002 2:52 PM > To: CF-Community > Subject: Why ain't it sorting? > > > Hey all, > > I think I'm having some temporary cognitive failure hee hee > > Whats wrong with this SQL? > > ------------- > Select > Team_Tbl.Service_Area,Team_Tbl.Cost_Center_Cd,Team_Tbl.Cost_Center_Desc, > > tblServiceArea.Service_Area,tblServiceArea.Service_Area_Desc > FROM tblServiceArea,Team_Tbl > > WHERE > tblServiceArea.Service_Area = Team_TBL.Service_Area > > > ORDER BY Trim(tblServiceArea.Service_Area_Desc) > --------------- > > > Umm..simple Order By statemnet...but it just doesn't sort. > It spits the records out in any old order...going from C to A then to > W..then T....I mean..what am I doing wrong? I know I gotta be doing > SOMETHING wrong..Just don't know what. > > ^_^ > > -Gel > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
