خودم به این نتیجه رسیدم
select EstekhdamSavabegTahsiliTbl.TagazaId,EstekhdamSavab egTahsiliTbl.Tahsilat,EstekhdamSavabegTahsiliTbl.R eshteh from EstekhdamSavabegTahsiliTbl,TagazaEstekhdamTbl where TagazaEstekhdamTbl.TagazaId=EstekhdamSavabegTahsil iTbl.TagazaId AND EstekhdamSavabegTahsiliTbl.Tahsilat Like N''+(Select MoshakhasatNiroTbl.Tahsilat from MoshakhasatNiroTbl where DarkhostId='" + DarkhostId + "') AND N'%'+(Select MoshakhasatNiroTbl.Reshteh from MoshakhasatNiroTbl where DarkhostId='" + DarkhostId + "')+'%' LIKE N'%'+ EstekhdamSavabegTahsiliTbl.Reshteh+'%' order by TagazaId Desc
از شما هم تشکر.