i have a table called "people" (name:varchar, lastname:varchar).
i do a select on it:
select * from people where name like '%n1%' or lastname like '%l1%'.
i would like the results in this order:
first the results that satisfy only the (name like '%n1%') condition, then the ones that satisfy only the (lastname like '%l1%') condition and last the results that satisfy both conditions.
Is this possible in only one SQL? (note that the search conditions n1 and l1 differ from search to search.
TNX, Gregor
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
