1、select case when isnumeric(a)=1 then '张三' else a end as name from table
2、select a,'' as b from table
posted on 2012-10-26 11:28 浪月悠虫 阅读(1094) 评论(0) 编辑 收藏 举报