[dbo].[CountCollection]

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@x	xml	max

CREATE FUNCTION [dbo].[CountCollection]
(@x XML) returns int
BEGIN
return isnull(@x.value('count(collection/item)','int'), 0)
END
GO