본문 바로가기

DataBase/Ms Sql

Ms Sql replace

select replace( menu_path, '/Lecture', '/Lecture2') from clsc..tcl_menu

where company_seq = 472   

and menu_path like '%/Lecture%'