UFN_TABLESPEC_GETENCRYPTEDFIELDS

                create function dbo.UFN_TABLESPEC_GETENCRYPTEDFIELDS(@TABLESPECXML xml) returns @T TABLE
                (
                COLUMNNAME nvarchar(100)
                )
                as 
                begin
                    insert into @T (COLUMNNAME)
                    select 
                        T.c.value('(@Name)[1]','nvarchar(100)')
                        from @TABLESPECXML.nodes(
                        'declare namespace bbt="bb_appfx_table";
                        /bbt:TableSpec/bbt:Fields/bbt:EncryptedField'
                        )
                        T(c)    

                    return
                end