Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Databases

Posted by Dylan Martin
Dylan Martin
10,399 Points

Expecting results like Lauren.Chalkley<at>example.com not Lauren.Chalkley<at>example.com.

SELECT REPLACE(email, "@", "<at>") as obfuscated_email from customers This query gives the desired results but is not counted correct. the tip given does not help.

2 Answers

Stuart Wright
Stuart Wright
41,118 Points
Stuart Wright
Stuart Wright
41,118 Points

I assume you're attempting this challenge:

https://teamtreehouse.com/library/reporting-with-sql/working-with-text/replacing-strings

I just copy/pasted your query in exactly and it worked for me and passed the challenge, so I'm not sure what's gone wrong.

Dylan Martin
Dylan Martin
10,399 Points
Dylan Martin
Dylan Martin
10,399 Points

Thanks for the reply. I copy pasted it and it worked as well. not sure what was going on.