Databases Reporting with SQL Working with Text Replacing Strings

Øystein Kallset
Øystein Kallset
3,200 Points

What is wrong with this SQL-statement: SELECT REPLACE(email,"@","<at>") FROM customers

Im getting: Expecting results like Lauren.Chalkley<at> not Lauren.Chalkley<at>

The problem is at:

1 Answer

37,594 Points

Hi Øystein,

You basically have it! Just remember to follow the instruction that asks you to alias your column as "obfuscated_email". So your completed code will look something like this:

SELECT REPLACE(email,"@","<at>") AS obfuscated_email FROM customers