Fantastic thats worked, your a star! Pardon my ignorance!

The only thing thats happening is that its creating a giant XML file with all the rows in, what i want it...

Do i need to?

Dbo.Payloads is the table?

Sorry im new to this!

Regards

Brendan

Of course doh! I said i was a newbie so forgive me O:)

Ive now got that to work, heres my query as it is:

SELECT

ContentReference,

LEFT(REPLACE(ContentReference,'H:\DAT\',''),(CHARINDEX('\',REPLACE(contentreference,'H:\DAT\',''),7)-1))

FROM

dbo.Payloads

In the Payloads table there is...

That seems to work many thanks, however, how do i get SQL to pull the data from a column in a table in a database rather than passing it strings?

e.g....