"This statement doesn't return anything." does it error out....i dont think it would.

replace your last line with...

Where rtrim(ltrim(c.emailaddress)) = 'allen.sherwood@yahoo.com'