Here's the query that @Elliott came up with to help me out: with CS (ConnectionString) as ( select cast(cast(substring(attrbinaryvalue,1,550) as varchar(550)) as xml) as ConnectionString from LawsonSN.dbo.ENPTREEATTRS where attrcategory = 5 ) select --CS.ConnectionString CS.ConnectionString.value('(/data_connection/name)[1]','varchar(50)') as DBName ,CS.ConnectionString.value('(/data_connection/jdbc_url)[1]','varchar(150)') as JDBCURL ,CS.ConnectionString.value('(/data_connection/jdbc_database)[1]','varchar(50)') as JDBCDatabase ,CS.ConnectionString.value('(/data_connection/jdbc_user)[1]','varchar(50)') as JDBCUser from CS
|