code:

---

SELECT
  CASE ((@IPADDRESS0) >= "10.197.0.1") AND ((@IPADDRESS0) <= "10.197.0.254")   $Server=Server1
  CASE ((@IPADDRESS0) >= "10.198.0.1") AND ((@IPADDRESS0) <= "10.198.0.254")   $Server=Server2
  CASE ((@IPADDRESS0) >= "10.199.0.1") AND ((@IPADDRESS0) <= "10.199.0.254")   $Server=Server3
ENDSELECT

---

Bill

[ 11 December 2001: Message edited by: bleonard ]