UFN_DATE_EARLIESTFROMFUZZYDATE

            create function dbo.UFN_DATE_EARLIESTFROMFUZZYDATE(@FUZZYDATE dbo.UDT_FUZZYDATE) 
            returns datetime
            as begin
                declare @YEAR as nchar(4);
                declare @MONTH as nchar(2);
                declare @DAY as nchar(2);
                set @YEAR = substring(@FUZZYDATE,1,4);
                if @YEAR='0000'
                    return null;
                set @MONTH = substring(@FUZZYDATE,5,2);
                set @DAY = substring(@FUZZYDATE,7,2);
                if @DAY = '00' begin
                    if @MONTH = '00'
                        set @MONTH = '01';
                    set @DAY = '01';
                end
                return convert(datetime, substring(@FUZZYDATE,1,4) + '-' + @MONTH + '-' + @DAY + 'T00:00:00');
            end;