Yep, this is the solution I came up with as well, but can anyone tell me why the "ORDER BY LEN(CtrlCode)" in my original post does not work??? Would prefer...

Well no, not exactly the same result but the SQL I am running now looks like:

DECLARE @WorkingString varchar(100)

CREATE TABLE #TempControls(

 CtrlCode varchar(3)

)

INSERT INTO #TempControls

VALUES ('T1')

INSERT INTO #TempControls

VALUES ('T2')

INSERT INTO #TempControls

VALUES ('T4')

INSERT...

True, but I still get the same result...

I would create a view that records customer ID, item ID and the average cost of their last 5 orders (Cust_ID, ItemID, AvgLast5Orders) using similar syntax to what you have in...

Each column has it's collation set individually so try:

declare @UserSegment table (UserID varchar(20) COLLATE Latin1_General_CI_AS, SegmentID varchar(20) COLLATE Latin1_General_CI_AS)

Just tried it in QA... works good as!

Taa,

B