shpakpe

Awesome I knew there had to be an easier way to do this LOL. Thanks for the help.

Hello Bluefunelmental, Thanks for your responce. All of these interfaces beging with irb in the interfacename field. So I can identify all the interfaces I want chagned with the following select query. SELECT * FROM [dbo].[Interfaces] WHERE [InterfaceName] Like 'irb%'