select obj_code, path, file_name, ol.lib_code from objects o inner join objlib ol on o.lib_code = ol.lib_code where upper(file_name) = upper('CAA.pdf') and upper(ol.path) like upper('%\download\act_regs\')
svOldAsset_Link=/wcmswr/_assets/main/download/act_regs/caa.pdf
svOldAsset_ObjCode={90653}
svOldAsset_simplePath={}
svOldAsset_path={D:\CASA_APPS\WCMS\PROD\WCMS621\Netsites\WCMS\Objects\_assets\main\download\act_regs\}
svOldAsset_filename={CAA.pdf}