sql--------case 语句

mysql

select
 case instr(fieldname,'.')>0
  when 1 then fieldname
  else concat(cast(fieldname as char),'.00')
 end as fieldname; 

mssql

declare @temp nvarchar(50)
declare @index int
set @temp='asdfasf/asdfas'
select charindex('/',@temp)
set @index=charindex('/',@temp)
print @index
select case @index
            when  8    then
   substring(@temp,charindex('/',@temp)+1,len(@temp)-charindex('/',@temp)-1) 
   else
     replace(@temp,'a','xxxx')  
       end as newfield