That works a charm - thank you very much for your help!

Yeah, I've read up on the differences and why nvarchar is the way forward, however this is in a product we didn't develop (but can play around with) so we...

I tried casting it to varbinary - not sure if that's what you mean...? But I still got the same result.

Screenshot of the extracted document (if it helps!) http://i.imgur.com/kGMYO.png

Unfortunately I'm now getting a crazily high number instead of the figure I was expecting!

In my version I'm seeing (when filtering down to one contractor:

Sales Invoice Purchase...

USE [Monarch_Pronet_ITOIL]

GO

/****** Object: StoredProcedure [dbo].[RPT_WHOS_MISSING] Script Date: 03/26/2012 15:39:10 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

--Report shows contract placements that we have invoiced - the pay and charge...

Hi,

no joy with that I'm afraid!

Thanks for that - I'll give that a whirl

CELKO (2/24/2012)

---

DECLARE @local_postal_code NVARCHAR(50);

No postal code on earth is fifty characters long; 12 is the worst I know. No postal code on earth uses Unicode. By international agreement, they are...

I've no idea (yet!) how that works, but it works a treat, thank you!

Thanks for that - I'll take a look at this and see how I get on!

Could you share the spreadsheet with me anyway, so I can take a look at...