Need Help (SQL)

[David]

"select title,txt from tbl_txt where title='%value%' or txt='%value%';"

I'd like to sort the result by title then by txt. How to do ?

Thank you.

[MAK]

select title,txt from tbl_txt where title='%value%' or txt='%value%' order by title,txt


------------
David at 6/15/01 8:53:33 AM

"select title,txt from tbl_txt where title='%value%' or txt='%value%';"

I'd like to sort the result by title then by txt. How to do ?

Thank you.

[Mark]

David,

Here is the complete query.

SELECT title
,text
FROM tbl_txt
WHERE title='%value%'
AND txt ='%value%'
ORDER BY title
,txt

This will give you the results that you want in the correct order.
Hope this helps.

Mark


------------
David at 6/15/01 8:53:33 AM

"select title,txt from tbl_txt where title='%value%' or txt='%value%';"

I'd like to sort the result by title then by txt. How to do ?

Thank you.

[Ananth]

If you're using the % wildcard, you should use LIKE, not =

otherwise your result set will be empty.




------------
David at 6/15/01 8:53:33 AM

"select title,txt from tbl_txt where title='%value%' or txt='%value%';"

I'd like to sort the result by title then by txt. How to do ?

Thank you.