Ravindra BagaleCourses & study guides Track your progress

Text Functions Analysts Use Daily — Ravi Sir's Cards

All SQL cards

Revision cards

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.
Clean text with trim, upper and lower · PNG

Interview cards

How 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 duplicates, so I check their IDs before I merge t
How do you match names that differ only in spaces or capitals? · PNG

Comparison cards

|| 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.
|| vs concat() when a value is NULL · PNG