Thanks Mike - that explains why it couldn't find the function when I tried last night!
You've actually got it slightly wrong here; it should be:
dbo.LCReturnVagueDate(s.vague_date_start,s.vague_date_end,s.vague_date_type) as Vague_date
So, I've inserted this, modified the Main Table and Column Names, but I now get the error:
EXECUTE permission denied on object LCReturnVagueDate, database 'NBNData', schema 'dbo'
By the way, it's your "LC1Detailed Species List 1or10kmV2.xml" report I'm experimenting with.
Cheers
Alan
Alan Hale
Aberystwyth