cast(lx as nvarchar) sqlserver 拼凑字符串

cast(lx as nvarchar) sqlserver 拼接字符串
select distinct cast(lx as nvarchar)+cast(sex as nvarchar)+ypname+cast(xueli as nvarchar),cast(nl as nvarchar)
from  sq_xm51jz.dbo.Zj_Yp where Ypc=2