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
  • Jeff Styles
    Jeff Styles
    2,784 Points

    Using LENGTH function as a condition without issuing an alias or displaying its value in output...

    Posted February 2, 2017 7:22pm by Jeff Styles
    Jeff Styles
    2,784 Points
    • Development Tools
    • Database Foundations
    • SQL Calculating, Aggregating and Other Functions
    • String Functions

    0 Answers

  • Sebas Pinto
    Sebas Pinto
    462 Points

    What benefit has manipulate Strings directly in the query and not in the Programming Language that i'm using for my app?

    Posted September 8, 2016 12:09am by Sebas Pinto
    Sebas Pinto
    462 Points
    • Development Tools
    • Database Foundations
    • SQL Calculating, Aggregating and Other Functions
    • String Functions

    1 Answer

  • Ricardo Vargas
    Ricardo Vargas
    3,583 Points

    Using functions better practices question

    Posted August 8, 2015 7:58pm by Ricardo Vargas
    Ricardo Vargas
    3,583 Points
    • Development Tools
    • Database Foundations
    • SQL Calculating, Aggregating and Other Functions
    • String Functions

    1 Answer

  • John Magee
    PLUS
    John Magee
    Courses Plus Student 9,058 Points

    Improper MySQL Syntax used in this Video - String Functions - Database

    Posted March 12, 2015 10:28pm by John Magee
    John Magee
    Courses Plus Student 9,058 Points
    • Development Tools
    • Database Foundations
    • SQL Calculating, Aggregating and Other Functions
    • String Functions

    0 Answers

  • Viktoria S
    Viktoria S
    6,773 Points

    How does sql know what is username? did we specified it earlier what is username consist of?

    Posted March 7, 2015 4:46pm by Viktoria S
    Viktoria S
    6,773 Points
    • Development Tools
    • Database Foundations
    • SQL Calculating, Aggregating and Other Functions
    • String Functions

    1 Answer

  • Sebastian Velandia
    Sebastian Velandia
    24,676 Points

    How to select star (*) but add a string function to one of the columns?

    Posted November 25, 2014 5:16pm by Sebastian Velandia
    Sebastian Velandia
    24,676 Points
    • Development Tools
    • Database Foundations
    • SQL Calculating, Aggregating and Other Functions
    • String Functions

    1 Answer

  • Joe Hilton
    PLUS
    Joe Hilton
    Courses Plus Student 4,893 Points

    Slightly confused with the SUBSTRING clause in my MySQL command.

    Posted July 31, 2014 5:39pm by Joe Hilton
    Joe Hilton
    Courses Plus Student 4,893 Points
    • Development Tools
    • Database Foundations
    • SQL Calculating, Aggregating and Other Functions
    • String Functions

    2 Answers

  • Joe Hilton
    PLUS
    Joe Hilton
    Courses Plus Student 4,893 Points

    Can anyone point me in the right direction as to what's wrong with my MySQL code please

    Posted July 31, 2014 4:32pm by Joe Hilton
    Joe Hilton
    Courses Plus Student 4,893 Points
    • Development Tools
    • Database Foundations
    • SQL Calculating, Aggregating and Other Functions
    • String Functions

    4 Answers

  • Bruno Calheira
    Bruno Calheira
    12,625 Points

    When should I use HAVING in SQL Statements?

    Posted July 2, 2014 8:06pm by Bruno Calheira
    Bruno Calheira
    12,625 Points
    • Development Tools
    • Database Foundations
    • SQL Calculating, Aggregating and Other Functions
    • String Functions

    2 Answers

  • Coders Unlimited
    Coders Unlimited
    10,112 Points

    Select the first letter of the "first_name", add a period after it, followed by a space and add the "last_name". Also, convert "last_name" to upper case. Call it "name". Example: "A. CHALKLEY".

    Posted February 27, 2014 6:42am by Coders Unlimited
    Coders Unlimited
    10,112 Points
    • Development Tools
    • Database Foundations
    • SQL Calculating, Aggregating and Other Functions
    • String Functions

    3 Answers

  • Coders Unlimited
    Coders Unlimited
    10,112 Points

    String Function

    Posted February 27, 2014 6:37am by Coders Unlimited
    Coders Unlimited
    10,112 Points
    • Development Tools
    • Database Foundations
    • SQL Calculating, Aggregating and Other Functions
    • String Functions

    2 Answers

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