cast every select of the union to varchar(8000) and you should be fine.

Can we see the code of the view and the udf?

Well not with strings .

ABS(Len(something) - 9)

Just to make sure that this value can't be negative.

How are you fetching/presenting the data? Check in the option of query analyzer (if you are using it). There's a maximum column size limit in there of 255...

As suggested, don't use that. Why aren't you using stored procs to do this work? It would avoid the problem altogether.

How about swapping the dates instead of raising an error and an output parameter instead of a select??

Did you need to consider the holidays in this proc too?

Sorry, you're on your own if you can't show the code.

The point of providing the insert statement is that I don't have to type the data. It also gives me a chance to work with the exact same data...

How do you setup the excel file (details please)?

If there's no answer to that then I have my answer to my error message .

HTH.

Same problem... would have to run an expansive search select twice.

This can get you started :

Best Practices Analyzer

Can't do squat without the inserts statements. I'm not gonna do your job for you unless you help yourself >>

Generate insert statements

Now that would be a OOPS.

Need the same version in VB 6 now?