区分本异地sql

update SmokeVehicle set IsLocal=1 where left(vlpn, 2)=‘冀F‘
update SmokeVehicle set IsLocal=2 where left(vlpn, 2)!=‘冀F‘ and left(vlpn, 1)=‘冀‘
update SmokeVehicle set IsLocal=3 where left(vlpn, 1)!=‘冀‘
update SmokeVehicle set IsLocal=4 where vlpn=‘‘ or vlpn is null

区分本异地sql

标签：date   where   null   lpn   and   local   异地   sql   eve