MS SQL 2000.
I have the following query
SELECT DISTINCT TOP 100 Word,Trans,WordID,IsExact,SetN,IsByWord,IsByPart FROM
(
SELECT Name as Word
, dbo.wa_getTranslationList(WordID) as Trans
, WordID
, CASE WHEN Name = @Word THEN 1 ELSE 0 END AS IsExact
, CASE WHEN Name LIKE @Word + '%' THEN 1...