Thanks Ramesh

The Solution you've given has put me on the right track.

Although the other solution is correct for the given example it's not generic.

Greg

Hi Matthew

I had a similar problem recently after the datatype of a column referenced by the view had been changed. It appeared that the view knew about the change (I...