select kode||to_char( id,'fm000000' )||'-'||to_char( urut_masuk, 'fm000000') regards,
pandu wp ________________________________ From: david wahyudi <[email protected]> To: [email protected] Sent: Mon, April 26, 2010 11:41:09 AM Subject: [indo-oracle] gabung field varchar dan number mas...mbak semua, gimana sih cara gabungin field varchar dan number biar hasilnya gak ada spasinya?? sql saya seperti ini : select kode||tochar( id,'000000' )||'-'||tochar( urut_masuk, '000000') from buku hasilnya sepert ini: XXX01 000001- 000001 biar hasilnya spt ini XXX01000001- 000001 tanpa spasi gimana??? [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
