A reader wanted only the values that mix letters and numbers from a column. Here is how to extract alphanumeric values from a string with simple pattern matching.
PostgreSQL – Storing Unicode Characters is Easy
PostgreSQL varchar can store Unicode with suitable database and client encodings. My example stores ЯНВАРЬ, the Russian word for January.
How to Sort a Varchar Column Storing Integers with Order By? – Interview Question of the Week #206
How do you sort a Varchar column storing integers with Order By when you cannot change the datatype? Here are two simple solutions I shared with a developer.
How to Trim TIME Part in DATETIME Values? – Interview Question of the Week #200
How to trim TIME part in DATETIME values? A reader wanted to keep only the date and the hour, so here are ways to cut off the minutes and seconds.
Collation Precedence: Which Collation Wins in a Comparison
Explain collation precedence with explicit and implicit labels, reproduce a conflicting join, and choose comparison rules.
Alphabets – SQL SERVER – Retrieving Rows With All Alphabets From Alphanumeric Data
I got an email from one of my blog readers asking for an easy way to identify if a given string contains only alphabets. There can be methods.
Tally Table: Replacing WHILE Loops With a Set of Numbers
Use a tally table or GENERATE_SERIES to replace repeated date, character, and missing-number loops with ordered sets of rows.