UFN_VALIDADDRESSFORMATPROCEDURE

            create function dbo.UFN_VALIDADDRESSFORMATPROCEDURE(@FORMATSQLFUNCTION nvarchar(200))
            returns bit
            with execute as caller
            as begin
                declare @NUMFIELDS int

                select @NUMFIELDS = COUNT(*) from INFORMATION_SCHEMA.PARAMETERS where SPECIFIC_NAME = @FORMATSQLFUNCTION and 
                    ((PARAMETER_NAME = '@ADDRESSID' and DATA_TYPE = 'uniqueidentifier' and ORDINAL_POSITION = 1) or
                    (PARAMETER_NAME = '@ADDRESSBLOCK' and DATA_TYPE = 'nvarchar' and ORDINAL_POSITION = 2 and CHARACTER_MAXIMUM_LENGTH = 150) or
                    (PARAMETER_NAME = '@CITY' and DATA_TYPE = 'nvarchar' and ORDINAL_POSITION = 3 and CHARACTER_MAXIMUM_LENGTH = 50) or
                    (PARAMETER_NAME = '@STATEID' and DATA_TYPE = 'uniqueidentifier' and ORDINAL_POSITION = 4 ) or
                    (PARAMETER_NAME = '@POSTCODE' and DATA_TYPE = 'nvarchar' and ORDINAL_POSITION = 5 and CHARACTER_MAXIMUM_LENGTH = 12) or
                    (PARAMETER_NAME = '@COUNTRYID' and DATA_TYPE = 'uniqueidentifier' and ORDINAL_POSITION = 6 ) or
                    (PARAMETER_NAME = '' and DATA_TYPE = 'nvarchar' and ORDINAL_POSITION = 0 and CHARACTER_MAXIMUM_LENGTH = 250))

                if @NUMFIELDS = 7
                    return 1

                return 0
            end