Thread: Help with If contains then
View Single Post
  #5 (permalink)  
Old May 2nd, 2008, 12:16 PM
mehere's Avatar
mehere mehere is offline
Global Sarcasm Mistress

  
Join Date: Mar 2008
Location: Wide Awake In Dreamland
Posts: 113
Thanks: 10
Thanked 21 Times in 19 Posts
Rep Power: 1
mehere is on a distinguished road

Awards Showcase
Microsoft SQL Server Classic ASP 
Total Awards: 2

Default
use an ORDER BY in your statement ... something like this
Code:
ORDER BY dbo.tblEQStatus.RegionID, SUBSTRING(dbo.tblEQStatus.Loc,CHARINDEX('-',dbo.tblEQStatus.Loc)+1,LEN(dbo.tblEQStatus.Loc))
this way all your "Ready" will be together, then all of your "Repair" in each region. Then it should display correctly.

Comments on this post
jmurrayhead agrees: indeed
__________________
Quote of the Month:
Strife: As long as we have each other, we'll never run out of problems.

Questions to Ponder:
Should vegetarians eat animal crackers?

iif([sarcasm]=true,iif([you have to ask]=true,"didn't work","ha ha ha"),"not sarcasm")
copyright © 2008 sbenj69
The Following User Says Thank You to mehere For This Useful Post:
Rebelle (June 17th, 2008)