Hi all,
Thanks for the responses.
Tom, SSCertifiable .. The query is being used in a SS Report so no issue about the DateTime breaking the app.
Steve(sgmunson) that worked...

Hi sgmunson,
the Case statement will not accept the code, I get

unless I'm doing it wrong
CASE
WHEN [Status]...

On the same issue I am adding more columns but, I have a field which is a DateTime and will not let me substitute the field with 'Out'.

CASE...

Thanks Lowell
that works a treat however I need to replicate that across all the columns, to hide all the details in the record. Do I just add the same...

Hi All,
I managed to find the problem in the end.
Sue H .. there was indeed another dependency on the replication (another orphaned replica job)
Once I deleted...

Any takers yet??
thanks

shahm10,
I am getting the following when trying to drop the distributor:

Msg 14071, Level 16, State 1, Procedure sp_dropdistpublisher, Line 110
Could not find the...