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

Reply via email to