I am working on quite an old MS SQL server as the back of a web application. I am making queries on a table which includes ‘surnames’ (Spanish), some of which are HTMLencoded and some are not. This does not matter on the web as the browser decodes and displays the text whether it is HTMLencoed or not. However, when I want to Order By ‘surnames’, I get unexpected results.
López << Not encoded
I really need a robust UDF or built in function which could parse the individual table row on a sort of HTMLdecode() and using the resulting value to decide the Sort By. That was I would simply call that function to elevate my listing problems.
I appreciate any help, advice or pointers. Perhaps there is a better way!
Many thanks for your help in advance.
Abiel M de Groot Sanders