Hi all,
 I have 2 columns as maxDistance and minDistance with datatypes decimal(18,2).their values are stored in datatbase as 23.00 60.00.i have a column in grid as distanceRange where i have to show my range as 23:60.so can u plz guide me in solving this.

hi there.. I don't know the database you are using, but this sound rather simple solved by the underlying query...just concat the 2 fields in your query the way you want...

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

Use following query:

Select CONVERT(int,minDistance) + ':' + CONVERT(int,maxDistance) from tableName

first use split method to get 23 out of 23.00 and 60 from 60.00 in two variables then combine them and show in grid.
if you still required code post again

thanks......

except that there is no native Split() function in TSQL (SQL Server, Access) which would require the original poster to find a split() function on the net and add it to their database, etc.

gaurav_jain2403's solution is the most straight forward way to do this.



================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for:
Professional Search Engine Optimization with ASP.NET

Professional IIS 7 and ASP.NET Integrated Programming

================================================== =========

Hi

  Gaurav,

        Thanks a lot. your trick works great!!!!

gourav
i did not understand yours comment on split function under my solution.
Please explain it.

thanks......