This was reported in a thread somewhere, but figure it's better to start a new one here:
When I don't put spaces before and after the code, when enclosed in CODE tags, I get nothing when I Preview Post -- and apparently also in the post itself. It does show up if put the CODE tags on their own lines. (Quote Post to see CODE)
update ubbt_USER_PROFILE set USER_AVATAR_WIDTH='64',USER_AVATAR_HEIGHT='64' where USER_AVATAR_WIDTH='0' and USER_AVATAR_HEIGHT='0'
vs
update ubbt_USER_PROFILE set USER_AVATAR_WIDTH='64',USER_AVATAR_HEIGHT='64' where USER_AVATAR_WIDTH='0' and USER_AVATAR_HEIGHT='0'