I don't understand why peppers are in the end of the list. Shouldn't they be between pepper and Pepper? 🙂
(to my knowledge)
Because here the "peppers" is plural. Of-course the number is always takes the first consideration
INSERT INTO #tbl_Avacado
Even 2 is plural and it contains number so the number gets sorted first and the 7 which is plural and it starts with caps so it is followed by the 6 in its ordinal position. Here also the weight of the word "pepper" will be less to the "peppers"
SELECT SOUNDEX ('pepper')
SELECT SOUNDEX ('peppers')
SELECT SOUNDEX ('p3pp3rs')
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.