Thanks all for the reply. I was able to pin point where problem is. In the query belowe if i remove Cast() part the query works without any errors. ANy...

No one has any suggestion!!!!!

--I can not disable the sorting option in this combo box because this combo box is stored in the table and this table contains other combo boxes along with this...

Following is the stored procedure I am using to insert dates in the drop down list. I have added comments in the code so that you can understand what I am trying...

Thanks Peter, but the query you sent me will work only when i am sorting it in the SQL query. I want my drop down (list) in the front end which is of...

Thanks. The second solution worked.

Thanks but it doesnot remove the decimal from the final value.

For example I ran the above query with @n=740002.64

SELECT RIGHT(REPLICATE('0', 13) + CONVERT(VARCHAR(15), 740002.64 ), 13)

I got the result as...

What is the purpose of this statement?

EXEC sp_msForEachTable 'EXEC sp_recompile ''?''' 

Thanks

thanks much

Can anybody answer my question please? I really need to know this.

Hi Ryan,

Sorry I didn't see your post before. I tried your script and it is working

That's great. Thanks a lot.This is really cool....

yes. I tried this function it returns 1 instead of 5.

Thanks Much all..

Kavita

Thanks much.That helped me a lot. I am going to try function instead of view.

Kavita

My text file is too large.  I can not import every thing in the table before I search it.

I only need to exctract one word for example 'WORK ORDER NUMBER'...