Hi,
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