I've never used a composite index actually.  What would be the result if I had separate indexes and then a composite index too?

Thanks!

James

Great recommendations! 

The only thing that I couldn't implement is this (Error: Incorrect sytax near the keyword as):

-- Derived table to build full name for each id

INNER JOIN

 (SELECT    id,...

I'm not sure this will do the trick, because there are multiple products and then multiple parts to each product. These products all need to show with there parts under...

That worked perfectly. Thanks Sushila!

SELECT REPLACE(child2, char(47), char(45)) AS Expr2

from cs_ArticleCategories

where id = 637

This displayed:

CSU-DSU

But when I ran this:

select child2 from cs_ArticleCategories

where child2 LIKE '%/%' and id = 637

It displayed:

CSU/DSU

How do I really update...

I run this:

SELECT REPLACE(child2, char(47), char(45)) AS Expr2

from cs_ArticleCategories

and this:

SELECT REPLACE(child2, '/', '-') AS Expr2

from cs_ArticleCategories

Then I run this and I get results of child2 values that have a forward slash...