Di sisi aplikasi atau di sisi database server ? kalau di sisi aplikasi bisa dengan fungsi format, contoh: format(varData,"#,##0.")
kalau di sisi database server, anda terpaksa melakukan pembulatan atau casting tipe data. salah satu fungsi pembulatan di sql server adalah round: select jumlah = round(300000.00,0) from tableanu aksan kurdin Pada tanggal 10/16/05, August sudana <[EMAIL PROTECTED]> menulis: > > saya buat query create table pada SQL server2000. > field : Harga typenya : money. > sewaktu "select * from Tbarang", result yang ditampilkan kolom field harga > adalah 300000.0000 > bgmn cara memformat type data tersebut agar pecahan 0 dibelakang koma > hilang?? > mohon pencerahan.. > terima kasih, > > "Damai Itu Indah.." > > ________________________________ > Yahoo! Music Unlimited - Access over 1 million songs. Try it free. > > Untuk keluar dari millis ini, kirim email kosong ke: > [EMAIL PROTECTED] > > > > > > ________________________________ > YAHOO! GROUPS LINKS > > > Visit your group "Programmer-VB" on the web. > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > ________________________________ > ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/k7folB/TM --------------------------------------------------------------------~-> Untuk keluar dari millis ini, kirim email kosong ke: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Programmer-VB/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
