SELECT Sys_Corporation.ID, Sys_Corporation.last_Name, Sys_Corporation.email,
(3 * dbo.WordCount('h', Sys_Corporation.last_Name) + dbo.WordCount

('h', Sys_Corporation.email)) *
CASE

WHEN 'h' IS NULL THEN 1

ELSE 3 * dbo.WordCount('ggg', Sys_Corporation.last_Name) + dbo.WordCount('ggh',

Sys_Corporation.email)

END AS Rank

FROM Sys_Corporation where rank>0 ORDER BY Sys_Corporation.Rank

为什么我加了where rank>0 这个就说“列名 'rank' 无效。”呢............

是运行的时候出问题的,编译没问题啊

是出不来数据！

这样 SELECT ID, '3+3' as rank
FROM Sys_Corporation where rank is not null也不行，是不是不能加条件呀

哦.这个是sql语句执行过程的问题,select的部分是在where之后执行的,所以找不到那个列

那怎么办!

加个子查询

怎么个加法呀，

select * from ( SELECT Sys_Corporation.ID, Sys_Corporation.last_Name, Sys_Corporation.email,
(3 * dbo.WordCount('h', Sys_Corporation.last_Name) + dbo.WordCount

('h', Sys_Corporation.email)) *
CASE

WHEN 'h' IS NULL THEN 1

ELSE 3 * dbo.WordCount('ggg', Sys_Corporation.last_Name) + dbo.WordCount('ggh',

Sys_Corporation.email)

END AS Rank

FROM Sys_Corporation where rank>0
) as b ORDER BY Rank 类似这样,自己去改改

好的，谢谢版主