::::::::::::::::::::::::::::



delete a  where Υ´嵥 is null
update  a  set f10=replace(f10,'.','-')
update  a  set f10='2006-02-04' where f10='206-02-04'



:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

--delete notifyinfo_old



--select * from a
--insert into notifyinfo_old
select 
f4 as cph,
f3 as carman,
'' as addr,
f6 as cartype,
f11 as carcolor,
convert(datetime,f10) as wfdate,
f9 as wfaddr,
convert(int,f7)   as wfcode,
convert(int,f12)  as wfmoney,
f16 as phone,
f8 as notifyno,
convert(datetime,f2) as createdate,
f5 as driveno,
'' as memo,
4 as userid,
convert(int,f13) as sxmoney,
'' as inputman,
'' as carpp,
6 as actionid,
case f15 
  when 'Ѵ' then 3
  else 1
end
 as stateid,
case f14
  when 'Ϻ' then 5
  when 'ɸ' then 6
when '' then 3
when '' then 2
when '' then 1
end
 as groupid
from a 