Another option is to provide mappings based on subnets by using the IsInSubnet() UDF. Example:
code:
select
case isinsubnet(@IPADDRESS0,'192.168.1.0/24')
use m: '\\server1\share'
case isinsubnet(@IPADDRESS0,'192.168.2.0/24')
use m: '\\server2\share'
endselect

For more info please see the FAQ Forum under TCP/IP Primer, Part I - IP Addresses
_________________________
There are two types of vessels, submarines and targets.