I am trying to write an SQL statement that will inspect one column of a table and return only the first letter of each word in the column.
For intance : The little red hen crossed the road
The reults would be : Tlrhctr.
Don't even ask why this is needed, our customer service department is trying to set up alternate keys for product lookup, and if we built a cross reference file that matched back to our Product Master, it would help in finding products.
Not even sure if this is possible, Thank you in advance fro anything you might be able to share on this.