Ah Jeff you are just too good to be true 😛

I did manage to create a working substring in the end:

CASE WHEN CHARINDEX( '/', AccountCode_FD, CHARINDEX( 'CA1-', AccountCode_FD )) >...

Thanks Jeff and Ron for your input - I am a bit of a T-SQL novice but I will take a look and try to relate this to my conundrum!

Thanks...

Here is some more info on what I would expect to see in the relevant output data:

I have to extract data into separate fields for the CA1, CA2, CA3... up...

Thanks Matt that sounds even better as we are looking to add this to a job!

Thanks again

- James

Thanks for that David sounds like it will do the trick!

Thanks for that, looks like it will do the trick!

Guys - thanks for your input so far!

What i really need this function/SP to do is list out the Remark Type (i.e. Insurance, Helath, Cancellation etc) then a carriage return...

Thanks guys!  The reason for using cusors is because the syntax needs to support both Sybase ASA7 and SQL Server DBMS's.  I think this is the only way to obtain...

Thanks guys,

I used this DBISAM supported syntax and it appears to do the trick:

SELECT SUBSTRING("defchgs"."OriginalValue" FROM 1 FOR 8000) AS OriginalValue FROM Table

-James

Hi Karl,

Thanks for that, but i get the error "Invalid length parameter passed to the substring function."  Does this make any sense to you?  The only error i've come across...

Thanks Ryan! I managed to use your template and apply it to my database with some tweaking to build in stop-overs etc.

Do you know if this sort of function can...

Thanks guys - i will give some of these a shot and let you know!

Thanks guys - i went with the simplified PARSENAME inbuilt function in the end!

The name string is read in from a third party app. into my database.  Most times there will be a last, first name and title, but sometimes the name might...

Thanks for the pasename suggestion - this will work most of the time, but on occassion the name might be just "LastName FirstName" or "LastName Title" unfortunately!

Any ideas/suggestions with the...