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

Reply via email to