How to use replace in sql

My table in sql consist of a column named LoginUserId which consists of users like 'user/abcd' now i have the requirement that i have to replace that with  'iser/abcd' how can i do that in sql i have nearly 1000 rows to update, do i have to use loop in sql ,please guide me