Skip to main content

Notice: Workspaces are undergoing maintenance and are temporarily unavailable.

🚀 In our NEW AI Bootcamp you'll build a working app in 28 days, no experience required. Free to all subscription levels.

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

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

  • Treehouse Logo
    • For Individuals
    • For Businesses
    • For Schools
    • For Libraries
    • For Military
    • All Courses
    • Tracks
    • AI Bootcamp
    • College Credit
    • Techdegree Bootcamps
    • Front End Development
    • Full Stack JavaScript
    • Code Adventures
    • Discord
    • Forum
    • Success Stories
    • Treehouse Links
    • 100 Days of Code
    • Explore
    • Career Toolbox
    • Free Treehouse Near Me
    • Affiliates
    • Blog
    • Support
    • About
    • Learn
    • Beginner's Guide to Coding
    • Data Analysis with SQL & Python
    • Front-End Web Development
    • Python Programming Basics
    • Techdegree Bootcamp Overview
    • UX Design Fundamentals
    • AI Tools for Beginners
  • For Individuals For Businesses For Schools For Libraries For Military
  • All Courses Tracks AI Bootcamp College Credit
  • Techdegree Bootcamps Front End Web Development Full Stack JavaScript
  • Code Adventures Discord Forum Success Stories Treehouse Links 100 Days of Code
  • Explore Career Toolbox Free Treehouse Near Me Affiliates Blog Support About
    Learn Beginner's Guide to Coding Data Analysis with SQL & Python Front-End Web Development Python Programming Basics Techdegree Bootcamp Overview UX Design Fundamentals AI Tools for Beginners
  • Sign In
  • Free Trial
Instagram Twitter Facebook YouTube LinkedIn
Loading banner... Start your free trial at Treehouse
    • Newest
      • Newest
      • Active
      • Unanswered
      • Featured
    • All Topics
      • All Topics
      • • General Discussion
      • • AI
      • • 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
      • • Vibe Coding
  • chris Gougherty
    chris Gougherty
    1,683 Points

    Issues understanding what is wrong with my code

    Posted January 11, 2022 10:53pm 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 October 18, 2021 4:13pm 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 October 10, 2021 1:13am 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 May 23, 2021 12:54pm 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 May 21, 2021 1:53am 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 May 12, 2021 10:05pm 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 November 22, 2020 1:36pm 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 October 30, 2020 8:21pm 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 October 12, 2020 2:42pm 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 October 9, 2020 12:00am 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 April 15, 2020 8:39pm 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 January 11, 2020 8:12pm 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 September 30, 2019 8:27pm 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 September 2, 2019 6:59pm 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 September 2, 2019 6:42pm 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 February 28, 2019 7:43am 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 February 3, 2019 7:31pm 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 January 28, 2019 8:44pm 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 October 19, 2018 12:47pm 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 October 9, 2018 12:07pm 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 September 29, 2018 10:31pm 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 August 11, 2018 5:34pm 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 June 20, 2018 10:28pm 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 June 15, 2018 1:10pm 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
    9,261 Points

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

    Posted June 15, 2018 4:13am by Michael Martin
    Michael Martin
    9,261 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 May 22, 2018 1:29pm 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.

Techdegree

  • Front End Web Development
  • Full Stack JavaScript
SEE ALL

Tracks

  • Learn to Code for Beginners
  • Beginning Python
  • Beginning SQL
  • Beginning Java
SEE ALL

Courses

  • JavaScript Basics
  • Intro to HTML & CSS
  • Python Basics
  • CSS Layout
SEE ALL

About Us

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

Explore

  • Plans
  • Affiliates
  • Perks
  • Shop
  • Free Treehouse Near Me
  • Treehouse for Libraries
  • Treehouse for Businesses

Treehouse is an online technology education platform founded in 2011. Treehouse offers more than 700 self-paced, video-based courses in web development, programming, data analysis, design, and AI, plus two project-based bootcamp programs in Front End Web Development and Full Stack JavaScript. Individual Treehouse plans start at $25 per month and include a 7-day free trial. Treehouse serves individual learners, businesses, schools, and public libraries. Cardholders at participating U.S. public libraries can use Treehouse for free. Select Treehouse courses, offered with University Pathways International, are recommended for college credit by ACE and NCCRS. Treehouse learners earn digital certificates for completed Tracks.

Terms & Conditions · Privacy · © 2026 Treehouse Island, Inc.
  • Twitter
  • YouTube
  • Facebook
  • LinkedIn
  • Instagram
  • Discord