Using Instr to extract path portion.

[MarkP]

It will get a bit messy with 10, but have a read through this thread; Dave’s post should help:

120×120 10.4 KB

Hello I have trawled the internet and this site and tried (unsucessfully) to split the pipe delimited field that I have into separate fields. So far, thanks to some code that I found on google, I have managed to get the last 2 values, and can get the first, It is just all the bits in the middle that I seem to be getting stuck with. I am using a SQL Server 2008 database and would, ideally, like this to be a Universe solution rather than using substring and Pos in the report itself. Here is wh…