It bugged me for awhile that people uses "zzz" to look up the last string with LOOKUP but when it comes to numbers then it's usually 10^308.
To it would make sense to use "ררר" or char(255) instead of "zzz". I actually wrongly did that in a few posts.
Then I figured maybe there is a reason for "zzz" so I ran some tests. The results surprised me, feeding the entire Ascii list into LOOKUP basically makes it go nuts.
Maybe I'm missing something here, have a look for yourself (attachmentent)
Bookmarks