gistfile1.txt

select * from aspnet_Users
where UserName like '%julianneyates%'

update aspnet_users
set loweredusername = LTRIM(RTRIM(loweredusername))
where UserName like '%julianneyates%'


update cs_users
set username = LTRIM(RTRIM(username))
where UserName like '%julianneyates%'

select * from cs_posts where postauthor like '%julianneyates%'

update cs_posts
set postauthor = LTRIM(RTRIM(postauthor))
where postauthor like '%julianneyates%'

update cs_posts
set postauthor