The BAT tool does not support VG248 import. The new version of BAT does not include this support either. I need to be able to import the appropriate information for 61 VG248's. This is way to many to bring in by hand. <br><br>I can see how to get the devices in the sql database. How do you find a subset in a device and then replace with a new value<br><br>i.e<br>device - SEP12345678901<br><br>needs to be VGC12345678901<br><br>I want to delete the SEP and replace with VGC. I need to be able to write an SQL statement that performs this operation.<br><br>Any ideas, I would appreciate any input.<br><br>Carl Fitzsimmons<br><br>cfitzsimmons@ronconet.com<br><br>