如何在TSQL中第一次出现单词之前替换

I have Select|_|8/1/2018|_|8/1/2018|_|Enter by Asset Type Here & Below|_|Enter Total Here|_||_|36|_||_||_|Select|_|8/1/2018|_|8/1/2018|_|Enter by