John Jason Jordan said the following, On 2008-02-25 18:17: > It turns out that what I needed to do can almost be done with > wildcards. That is, a WHERE field LIKE '%FE1a-???%' will pick up all > records where FE1a- exists anywhere in the field. The problem is that I > also need the query to sort the data on the ???, which is the number > that the question will be in the exam. I couldn't get it to sort on the > expression, only on the entire contents of the field.
This makes me wonder whether you have attempted to "simulate" table structures by glueing different kinds of information within a single field. The same can be achieved by having many fields and combining them only when you want to display them in a specific format -- in queries, forms or reports. Lack of appropriate functions built into Kexi's SQL engine makes that currently hard, though. Thanks for using Kexi. -- regards / pozdrawiam, Jaroslaw Staniek Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on Kexi & KOffice (http://www.kexi.pl/en, http://www.koffice.org/kexi) KDE Libraries for MS Windows (http://windows.kde.org) _______________________________________________ Kexi mailing list [email protected] https://mail.kde.org/mailman/listinfo/kexi
