query to find the column value in another table

Hi krishh,

Please try the following codes:

SELECT  SUBSTRING(LTRIM(rtrim(col1)),0,charindex(':',LTRIM(rtrim(col1)))) FROM #MOUNTVOL a WHERE   EXISTS ( SELECT 1 FROM sys.database_files WHERE  physical_name LIKE a.COL1 + '%' ) ;

Best Regards,

Allen Li

---

Allen Li

TechNet Community Support