Windowing functions aren't just for analyzing numbers/dates. Using windows functions to analyze when a character field changes is a little know resource
2017-03-17 (first published: 2016-02-17)
Special Characters can lead to many problems. Identifying and reporting on them can save a lot of headache down the road.
2016-04-08 (first published: 2014-08-19)