Some Useful String Functions in SQL
Let’s try to have a look at some SQL functions that are not very popular but can be very useful in some cases. Let’s imagine that we have the following task: replace all letters in a varchar column between first and last spaces with symbol ‘*’. The task can be…