SQL select statement - returning records starting with variable length string
- by alpheus
I am using an alphabetical sorting feature and need a SQL statement to return records beginning with a variable length string. However, records also need to be returned if there are periods, spaces, or dashes between any of the characters in the string.
For example, the string could be "M" (easy). Or "MA" (in which case it needs to return…