I have a table with multiple rows like this:
if not exists (select * from dbo.sysusers where name = N'GA\ggalligan') Exec sp_grantdbaccess N'GA\GA\ggalligan', N'GA\ggalligan'
I need to remove the first GA\ where it says GA\GA\ggalligan. All the rows are different lengths, so it always can't start in the same place. This needs to be an update statement. Any help would be much appreciated.