Hi Mr.MOGHE, Thank you for your reply. But this seems like not working for me . The grid column does not get sorted properly on time when you specify AM and PM along with date and time. ShreejaRajan

Hi Forum, I would like to include Indexing Server in my aaplication which uses Sql 2000 for its backend processing. I have Encountered a problem in Querring Indexing Server Catalogs. Could anyone help me to querry indexing server catalogs for searching files having the keyword as mentioned below: ASP(4) and JAVA(3) i am trying to query the indexing server to find all the word documents which has text "ASP" six times and the text "JAVA" three times in it. the following query works fine for the keyword: ASP and Java SELECT * FROM OPENQUERY(WEBCATALOG, 'SELECT FileName, Path, VPath FROM SCOPE(''DEEP TRAVERSAL OF("/Info")'') WHERE CONTAINS(''asp and java'') ') Could anyone help me to solve this problem of specifying the no of hits of each keyword in the query. ShreejaRajan

thank you very much Mr. Graus for your support ShreejaRajan

Hi, all Can any one please help me out to Sort Datetime Column in a Datagrid (asc or desc)? I am finding problem in the Sort property of Dataview which does not sort the Datetime column in the datagrid properly (Ascending or descending) . I want to avoid using "order by" option in the sql statement . Thanks in Advance Shreeja. ShreejaRajan