๐Ÿค‘ Join the Treehouse affiliate program and earn 25% recurring commission!

New No-Code Track! ๐Ÿš€ New videos dropping every weekโ€”start learning today!

๐ŸŒŸ Dreaming of a bright future? ๐ŸŽ“ Ask about the Treehouse Scholarship program! ๐Ÿš€

โœจ Earn college credits in Cybersecurity, JS, HTML, CSS and Python

  • 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
    • Community Projects
    • Live Sessions
    • 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
  • Community Projects Live Sessions 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
  • 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
    8,653 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
    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 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.

    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.