DB Query

[goa]

New Message on dotNET User Group Hyd DB Query Reply   Reply to Sender   Recommend Message 1 in Discussion From: goa Hi all, There's a requriement to retrieve the records from DB (SQL Server 2000), based on the text search. Say, table A contains some x fields. In one of those fields we store the text content (say resume as pure text ). Now when we search for some particular text (could be SAP, oracle,...), my query should retrive the records based on the maximum word count. First record with max. word could should display........and so on.(i.e, order by the maximum word count) If u have solution le me know imme. If not any logic as how to do................. Regards, Goa. View other groups in this category. Also on MSN: Start Chatting | Listen to Music | House & Home | Try Online Dating | Daily Horoscopes To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. Need help? If you've forgotten your password, please go to Passport Member Services. For other questions or feedback, go to our Contact Us page. If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. Remove my e-mail address from dotNET User Group Hyd.