Thx Friends, cm masalahnya field sebenarnya ada 30...:( pusing juga yah..combinasinya tambah rame donk ? ok lah..thx utk jawabannya..:)
--- In [email protected], Igit Syah Riza <[EMAIL PROTECTED]> wrote: > > itu pasti 5 field yaa.. kalo iya coba gini, misal yang mo di tampilin field1,field2,field3 > > SELECT CASE > WHEN field1 IS NULL THEN field2&','&field3 > WHEN field2 IS NULL THEN field1&','&field3 > ELSE field1&','&field2&','&field3 > END > FROM nama_table > > coba dulu dech.. good luck. > > ----- Original Message ---- > From: kislew_mm <[EMAIL PROTECTED]> > To: [email protected] > Sent: Friday, 27 April, 2007 3:38:19 PM > Subject: [indoprog-vb] mau tanya hilangin separator di query sql server > > > > > > > > > > > > > > salam prog vb. > > saya buat table disql server > > > > field1, field2, field3, field4, field5 > > 1 3 4 <-- isi record 1 > > 2 5 <-- isi record 2 > > > > trus saya mau tampilinnya 5 field dlm SATU kolom pakai separator, > > saya lakukan > > select field1 + ',' + field2 + ',' + dst... > > hasilnya jadi gak bagus. > > > > field_gabungan > > 1,,3,4, > > ,2,,,5 > > > > bagaimana supaya hasilnya seperti ini : > > > > field_gabungan > > 1,3,4 > > 2,5 > > > > jadi setiap ',' akan hilang klo isi fieldnya memang kosong. > > > > tapi secara query sql server aja. tanpa bantuan vb.gimana yah ? > > > > terima kasih. > > > > > > > > > > > > > > > <!-- > > #ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;} > #ygrp-mlmsg table {font-size:inherit;font:100%;} > #ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;} > #ygrp-mlmsg pre, code {font:115% monospace;} > #ygrp-mlmsg * {line-height:1.22em;} > #ygrp-text{ > font-family:Georgia; > } > #ygrp-text p{ > margin:0 0 1em 0;} > #ygrp-tpmsgs{ > font-family:Arial; > clear:both;} > #ygrp-vitnav{ > padding-top:10px;font-family:Verdana;font-size:77%;margin:0;} > #ygrp-vitnav a{ > padding:0 1px;} > #ygrp-actbar{ > clear:both;margin:25px 0;white-space:nowrap;color:#666;text- align:right;} > #ygrp-actbar .left{ > float:left;white-space:nowrap;} > .bld{font-weight:bold;} > #ygrp-grft{ > font-family:Verdana;font-size:77%;padding:15px 0;} > #ygrp-ft{ > font-family:verdana;font-size:77%;border-top:1px solid #666; > padding:5px 0; > } > #ygrp-mlmsg #logo{ > padding-bottom:10px;} > > #ygrp-vital{ > background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;} > #ygrp-vital #vithd{ > font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text- transform:uppercase;} > #ygrp-vital ul{ > padding:0;margin:2px 0;} > #ygrp-vital ul li{ > list-style-type:none;clear:both;border:1px solid #e0ecee; > } > #ygrp-vital ul li .ct{ > font-weight:bold;color:#ff7900;float:right;width:2em;text- align:right;padding-right:.5em;} > #ygrp-vital ul li .cat{ > font-weight:bold;} > #ygrp-vital a { > text-decoration:none;} > > #ygrp-vital a:hover{ > text-decoration:underline;} > > #ygrp-sponsor #hd{ > color:#999;font-size:77%;} > #ygrp-sponsor #ov{ > padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;} > #ygrp-sponsor #ov ul{ > padding:0 0 0 8px;margin:0;} > #ygrp-sponsor #ov li{ > list-style-type:square;padding:6px 0;font-size:77%;} > #ygrp-sponsor #ov li a{ > text-decoration:none;font-size:130%;} > #ygrp-sponsor #nc { > background-color:#eee;margin-bottom:20px;padding:0 8px;} > #ygrp-sponsor .ad{ > padding:8px 0;} > #ygrp-sponsor .ad #hd1{ > font-family:Arial;font-weight:bold;color:#628c2a;font- size:100%;line-height:122%;} > #ygrp-sponsor .ad a{ > text-decoration:none;} > #ygrp-sponsor .ad a:hover{ > text-decoration:underline;} > #ygrp-sponsor .ad p{ > margin:0;} > o {font-size:0;} > .MsoNormal { > margin:0 0 0 0;} > #ygrp-text tt{ > font-size:120%;} > blockquote{margin:0 0 0 4px;} > .replbq {margin:4;} > --> > > > > > > > > > ___________________________________________________________ > Yahoo! Mail is the world's favourite email. Don't settle for less, sign up for > your free account today http://uk.rd.yahoo.com/evt=44106/*http://uk.docs.yahoo.com/mail/winter 07.html > > [Non-text portions of this message have been removed] >
