I have a query that I need to order by two fields. I currently have this<BR><BR>SELECT ...<BR>//Rest of Query <BR>ORDER BY IRDCatType, IRPCol<BR><BR>The problem I have is IRDCatType has values of:<BR>Other<BR>Other Savings Dep<BR><BR>When these get compared SQL thinks they are equal. Is there anyway to force it to compare the entire string? I am using SQL Server 7.0<BR><BR>Thanks