problem in sorting

[radhika8421]

hi friends ,

i got a problem in sorting the numbers.Dataent ry people entered the value of the price fields as 12000 $12349 24,890..... in this format into the database price feild so i am not able to sort the price values into the dropdown menu box on the htmlpage.String tokenizer is not working in the jsp page.so please anybody can help me.

[Niheel]

You could write code that would strip the dollar signs and commas out of the data and then maybe store the clean data in a temporary table or add a column to your current table called clean_prices