Thanks, but that gives these error messages:
Server: Msg 7357, Level 16, State 2, Line 1
Could not process object 'SELECT 0 AS MANUAL,C.HMO,C.ID,C.CLAIM,C.LINE,C.ORIG_CLM_NUM,C.PX_DE,C.PX__PROCEDURE_CODE,C.PX__NAME,MBCL.MOD AS MOD_DE,
D5.MODIFIER_CODE AS MOD__MODIFIER_CODE,
= C.PX__PROCEDURE_CODE + '-'...