✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

🤑 Join the Treehouse affiliate program and earn 25% recurring commission!

New No-Code Track! 🚀start learning today!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

✨ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

🤑 Join the Treehouse affiliate program and earn 25% recurring commission!

  • Treehouse Logo
  • Plans
    Chevron
    • For Individuals
    • For Businesses
    • For Schools
    • For Libraries
    • For Military
  • Library
    Chevron
    • All Courses
    • Tracks
    • College Credit
  • Techdegree
    Chevron
    • Overview
    • Front End Development
    • Full Stack JavaScript
    • Data Analysis
    • UX Design
    • Python
  • Community
    Chevron
    • Code Adventures
    • Discord
    • Forum
    • Success Stories
    • Treehouse Links
    • 100 Days of Code
  • Resources
    Chevron
    • Career Toolbox
    • CodeForward
    • Free Treehouse Near Me
    • Jobs
    • Blog
    • Support
    • About
  • For Individuals For Businesses For Schools For Libraries For Military
  • All Courses Tracks College Credit
  • Overview Front End Web Development Full Stack JavaScript Python Development Data Analysis UX Design
  • Code Adventures Discord Forum Success Stories Treehouse Links 100 Days of Code
  • Career Toolbox CodeForward Free Treehouse Near Me Jobs Blog Support About
  • Sign In
  • Free Trial
Instagram Twitter Facebook YouTube LinkedIn
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • AI
      • • Android
      • • APIs
      • • Coding for Kids
      • • College Credit
      • • Computer Science
      • • CSS
      • • Data Analysis
      • • Databases
      • • Design
      • • Development Tools
      • • Digital Literacy
      • • Game Development
      • • Go Language
      • • HTML
      • • Java
      • • JavaScript
      • • Learning Resources
      • • Machine Learning
      • • No-Code
      • • PHP
      • • Professional Growth
      • • Python
      • • Quality Assurance
      • • React
      • • Ruby
      • • Security
      • • Swift
    • Showing results for:
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings
    • Close
  • chris Gougherty
    chris Gougherty
    1,683 Points

    Issues understanding what is wrong with my code

    Posted on Jan 11, 2022 by chris Gougherty
    chris Gougherty
    1,683 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings

    1 Answer

  • Jose Testa
    Jose Testa
    2,051 Points

    How to replace just one character "@" from every entry on the email column.

    Posted on Oct 18, 2021 by Jose Testa
    Jose Testa
    2,051 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings

    2 Answers

  • Em Noble
    Em Noble
    6,979 Points

    what is wrong with my code?

    Posted on Oct 10, 2021 by Em Noble
    Em Noble
    6,979 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings

    1 Answer

  • Alessandro Pappacena
    Alessandro Pappacena
    2,589 Points

    Problem with this challenge, what am I missing?

    Posted on May 23, 2021 by Alessandro Pappacena
    Alessandro Pappacena
    2,589 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings

    1 Answer

  • Tanya Townsend
    Tanya Townsend
    11,692 Points

    Weird/unclear error message

    Posted on May 21, 2021 by Tanya Townsend
    Tanya Townsend
    11,692 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings

    1 Answer

  • Sachin Parkash
    Sachin Parkash
    2,590 Points

    replacing strings of text task 1

    Posted on May 12, 2021 by Sachin Parkash
    Sachin Parkash
    2,590 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings

    1 Answer

  • Van Nguyen
    Van Nguyen
    3,533 Points

    The code was correct but the Bummer expected weirdly.

    Posted on Nov 22, 2020 by Van Nguyen
    Van Nguyen
    3,533 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings

    0 Answers

  • Jenn Giulietti
    Jenn Giulietti
    4,888 Points

    REPLACE SQL

    Posted on Oct 30, 2020 by Jenn Giulietti
    Jenn Giulietti
    4,888 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings

    1 Answer

  • John Richter
    John Richter
    2,351 Points

    how to replace a single piece of a randomly placed character in a substring.

    Posted on Oct 12, 2020 by John Richter
    John Richter
    2,351 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings

    2 Answers

  • Talon Ward
    Talon Ward
    2,495 Points

    SELECT REPLACE(email, "@" "<at>") AS "obfuscated_email" FROM customers; What am I missing here?

    Posted on Oct 9, 2020 by Talon Ward
    Talon Ward
    2,495 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings

    1 Answer

  • Taylor Han
    Taylor Han
    2,406 Points

    REPLACE function with SQL

    Posted on Apr 15, 2020 by Taylor Han
    Taylor Han
    2,406 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings

    1 Answer

  • Mohd Aamir Mir
    Mohd Aamir Mir
    3,281 Points

    select email from customers where REPLACE(email,"@","<at>") as obfuscated_email;

    Posted on Jan 11, 2020 by Mohd Aamir Mir
    Mohd Aamir Mir
    3,281 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings

    1 Answer

  • Sharim Babar
    Sharim Babar
    2,647 Points

    My result looks like the example but it is still wrong, why is that?

    Posted on Sep 30, 2019 by Sharim Babar
    Sharim Babar
    2,647 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings

    1 Answer

  • Carol Garcia
    Carol Garcia
    1,875 Points

    Second attempt.

    Posted on Sep 2, 2019 by Carol Garcia
    Carol Garcia
    1,875 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings

    1 Answer

  • Carol Garcia
    Carol Garcia
    1,875 Points

    Code check.

    Posted on Sep 2, 2019 by Carol Garcia
    Carol Garcia
    1,875 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings

    1 Answer

  • Øystein Kallset
    Øystein Kallset
    11,044 Points

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

    Posted on Feb 28, 2019 by Øystein Kallset
    Øystein Kallset
    11,044 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings

    1 Answer

  • Andrzej Szelemetko
    Andrzej Szelemetko
    25,447 Points

    replace(email, '@', '<at>') problems in task I am getting the following error: Bummer: Expectin

    Posted on Feb 3, 2019 by Andrzej Szelemetko
    Andrzej Szelemetko
    25,447 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings

    1 Answer

  • Jeremy Jones
    Jeremy Jones
    886 Points

    Unclear what the desired answer is, again

    Posted on Jan 28, 2019 by Jeremy Jones
    Jeremy Jones
    886 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings

    1 Answer

  • Rhea Khanna
    Rhea Khanna
    2,838 Points

    REPLACE function

    Posted on Oct 19, 2018 by Rhea Khanna
    Rhea Khanna
    2,838 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings

    1 Answer

  • Ross O'Neill
    Ross O'Neill
    2,884 Points

    stuck on this challenge

    Posted on Oct 9, 2018 by Ross O'Neill
    Ross O'Neill
    2,884 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings

    0 Answers

  • Karen Shumate
    Karen Shumate
    13,579 Points

    Write a query that will retrieve all email addresses but will replace the @ symbol with <at> so they all look like andre

    Posted on Sep 29, 2018 by Karen Shumate
    Karen Shumate
    13,579 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings

    1 Answer

  • Haisam Elkewidy
    Haisam Elkewidy
    26,987 Points

    correct answer is being interpreted by the site as incorrect

    Posted on Aug 11, 2018 by Haisam Elkewidy
    Haisam Elkewidy
    26,987 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings

    1 Answer

  • joshua inyang
    joshua inyang
    948 Points

    I've tried running it in the playground but I'm not seeing my error

    Posted on Jun 20, 2018 by joshua inyang
    joshua inyang
    948 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings

    1 Answer

  • barak ben ishay
    barak ben ishay
    1,951 Points

    how to replace

    Posted on Jun 15, 2018 by barak ben ishay
    barak ben ishay
    1,951 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings

    3 Answers

  • Michael Martin
    Michael Martin
    8,653 Points

    What is wrong here? I don't understand the output matches against itself

    Posted on Jun 15, 2018 by Michael Martin
    Michael Martin
    8,653 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings

    2 Answers

  • Troy Erby
    Troy Erby
    6,332 Points

    Having trouble with Reporting SQL with the REPLACE function

    Posted on May 22, 2018 by Troy Erby
    Troy Erby
    6,332 Points
    • Databases
    • Reporting with SQL
    • Working with Text
    • Replacing Strings

    1 Answer

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.

    Treehouse

  • About
  • Blog
  • Careers
  • Community
  • Stories
  • Shop
  • Contact
  • Gift Card

See Full Catalogue

Techdegree

  • Front End Web Development
  • Full Stack JavaScript
  • Python Development
  • Data Analysis
  • UX Design

Tracks

  • Learn to Code for Beginners
  • Beginning Python
  • Beginning SQL
  • Beginning Java
  • ...see more

Courses

  • JavaScript Basics
  • Intro to HTML & CSS
  • Python Basics
  • CSS Layout
  • ...see more

Explore

  • Plans
  • Affiliates
  • Perks
  • Free Treehouse Near Me
  • Treehouse for Libraries
  • Treehouse for Businesses
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
Terms & Conditions | Privacy

© 2025 Treehouse Island, Inc.