I have currently written a way to rank fixed length DataSets however I am looking for additional methods which can be used to improve the ranking and results.
See the dataset below with the test data:
[Fixed Length Column 1]
This is a test subject
This is test subject01
Ideally what I used was the empty space characters which are removed / trimmed to get the rank. It would be good to get more meaningful results driven out of dataset.
Here is how I am doing it:
LEN(TRIM(This is a test subject)) = 22 with spaces and 18 without them
LEN(TRIM(This is test subject01)) = 22 with spaces and 19 without them
First published under:
http://www.codeproject.com/Articles/808347/Ranking-Fixed-Length-Search-Results