Thanks guys, I went with the case method and its working nicely for me, thanks for your help

: )

Yeh, I think avoiding SP_OACREATE might be the key here!! I'm currently working on doing this via a CLR UDF.... just have some security issues to get round first....