isnull 如果为null 的时候的替换字符
select top 10 isnull(bjsj,'空') as bjsj from spworklist
case 条件判断dqzt 字段 -1 返回当前-1 如果是 3 返回当前是3 否则不是-1也不是-3
select top 10 case dqzt when -1 then '当前是-1' when 3 then '当前是3' else '不是-1也不是-3' end as dqzt from spworklist
cast类型转换函数
-- Use CAST.
USE pubs
GO
SELECT SUBSTRING(title, 1, 30) AS Title, ytd_sales
FROM titles
WHERE CAST(ytd_sales AS char(20)) LIKE '3%'
GO
-- Use CONVERT.
USE pubs
GO
SELECT SUBSTRING(title, 1, 30) AS Title, ytd_sales
FROM titles
WHERE CONVERT(char(20), ytd_sales) LIKE '3%'
GO