Ravindra BagaleCourses & study guides Track your progress

Text Functions Analysts Use Daily

By Last updated:

Lessons in this chapter:

  1. 10.1 How to Clean Text with trim(), upper() and lower()
  2. 10.2 How to Glue Text with || and concat() (Names and Labels)
  3. 10.3 How to Search Inside Text with LIKE and instr()
  4. 10.4 How to Cut Text with substr()
  5. 10.5 Practice: Clean Agent Names and Check Hub Codes

Quiz for this chapter is available on the Learn tracker after deploy.

Ravindra Bagale's Tip

Finish every lesson example in DB Browser before the quiz.

Ravi Sir's Cards for this chapter

Clean text with trim, upper and lower. Hand-typed names often have extra spaces and mixed capitals. Then one name can look like two different names in a report.Revision cardHow do you match names that differ only in spaces or capitals? I compare lower(trim(name)) on both sides. A match only means the two rows are possible duplicateInterview card|| vs concat() when a value is NULL. Both join pieces of text. || is the standard SQL operator, and concat() is a function available in SQLite 3.44 and later.Comparison card

All cards for this chapter