select 'haha'+Convert(varchar,id) as haid
from table
或或select 'haha'+CAST(id as varchar) as haid
from table
posted on 2007-04-07 14:12    阅读(326)  评论(1)    收藏  举报