(to clarify, this is for a SQL Server 7.0 system, which now looking at this forum, is probably mis-posted)

well, basically, here's the story,

there's a table called CA_Categories what has a...