Sorry sorry..this is Oracle..forget the Trim thing I took that out..I was trouble shooting..
-Gel -----Original Message----- From: Timothy Heald [mailto:[EMAIL PROTECTED]] 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]] > > 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_Des > c, > > 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 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
