Ask a question: in the SQL Server custom sort ORDER BY CHARINDEX limit problem of the characters, I use less characters can custom sorting, if more than 4000 sort is messed up, whether the SQL string limited bytes, if so, there is no other better way can replace

CodePudding user response:

Don't understand what you mean, the table structure and the sample data is posted,

CodePudding user response:

The building Lord when charindex superposition try adding some special characters, such as: here is to join the special character "|"
Essentially a custom sorting method to share