update en lot des nodes

Post date: Dec 10, 2015 6:09:18 PM

Select Caption, IP_Address from NODES

WHERE IP_Address like '%.21.%' or

IP_Address like '%.22.%' or

IP_Address like '%.20.%'

Update NODES

Set Site = 'Corp'

WHERE

IP_Address like '%.21.%' or

IP_Address like '%.22.%' or

IP_Address like '%.20.%'