hai nithi

try to use the following format which u needed

If you use SQLSERVER, you can try the below sql statement.

SELECT CONVERT(char, DateOfBirth, 105) AS Date_Column FROM ...

hai Jeff Moden,

Thank for solution and two link given below from u post.

i realize what mistake done by me.

And once again thank for your valueable post and i learned

Cross Tabs...

hai...

i have attached the example see that and let me know the solution

hai Veteran

Thanks for u reply

compare two value

value1:100

value2:104

the value2 is nearest to value1 so

100(value1) compare 104 (value2) and round nearest value2 to value1

100(compare)104 ==> (nearest)100

i think so it must be...

hai SSC-Enthusiastic,

very.................. thanks..

thanks for your valuable post,i am new to this forumn, where i have give point or "MARK AS ANSWER"

Thanks/regards

ramesh.d

hai customer,

Thanks for ur reply

please find the attachment and reply your query as for the given structure..

Thanks/regards

ramesh