1、select case when isnumeric(a)=1 then '张三' else a end as name from table
2、select a,'' as b from table
1、select case when isnumeric(a)=1 then '张三' else a end as name from table
2、select a,'' as b from table
转载于:https://www.cnblogs.com/xieon1986/archive/2012/10/26/2740848.html