Dear sqlite experts, I have an application where data stored in columns can be lists of integers (e.g. 158;42;76). I cannot really split such record into multiple records (one for 158, one for 42 etc) and I am currently storing them as VARCHAR because they represent a complete piece of information. However, when I select records, I would like to compare or match any of the values. For example, the record could be selected by either
C > 100 (match 158) C < 100 (match 42 and 76) C = 42 (match 42) >From what I have read so far, I could define a special collate function for these columns (sqlite3_create_collation etc), but before I jump into the details, does anyone know 1. Is this the correct way to proceed? 2. Has anyone done anything similar so that I do not have to reinvent the wheel? Thank you very much, Bo _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
