Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

truncating the digits after decimal in sql server2000

3 Posts 2 Posters 0 Views 1 Watching

V Offline
V Offline
vivek g

wrote on last edited by

#1

the value 1233.65774858 what i need 1233.65 but i am getting 1233.6500000000 vivek
R 1 Reply Last reply

0
V vivek g

the value 1233.65774858 what i need 1233.65 but i am getting 1233.6500000000 vivek
R Offline
R Offline
Rana Muhammad Javed Khan

wrote on last edited by

#2

Use Convert Function convert(decimal(10,2), 1233.65774858) Regards, Javed
V 1 Reply Last reply

0
R Rana Muhammad Javed Khan

Use Convert Function convert(decimal(10,2), 1233.65774858) Regards, Javed
V Offline
V Offline
vivek g

wrote on last edited by

#3

thanks mr. khan the method is really cool. vivek -- modified at 4:39 Monday 6th February, 2006
1 Reply Last reply

0

Log in to reply