I am looking for the best T-SQL solution. Hints are just given for problem statement, they should not be used hard-wired in the solution algorithm. Spaces can be trimmed right & left, reduced to single space in middle.
It can be assumed that the following ranges are distinquished [a-z], [A-Z], [0-9]. Lookup table support can be added as last resort.
Good luck and thanks.
View Complete Post