diallonina (1/24/2012)
I've tried SQL Kiwi solution and it doesn't work :hehe:
It worked for the sample data you provided :hehe: :hehe: :hehe:
Look, images are not easy for us to work with - if you want a definitive answer, provide test data in the form I did: CREATE TABLE with INSERT statements. From what you have said, it might be worth looking trying the SQL_Latin1_General_CP437_CI_AI collation, but I am not about to transcribe images into test data for you to test that out.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi