Rekan VBer's
 
saya punya data seperti ini
 
KD_MTK      Nilai      Nilai Huruf
IF-110            4              A
IF-111            2              C
 
 
Kalo kita mo buat nilai huruf pada Access tentunya pada Query khan tinggal pake 
Nilai_huruf:IIF(nilai =4,'A',IIF(nilai=3,'B',IIF(nilai = 2, 'C', 
IIF(Nilai=1,'D','E'))))
 
Gimana caranya ya.. kalo di SQL Server. Tolong banget buat yang uda bisa.
 
  


regards,
Trisno
__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[Non-text portions of this message have been removed]



------------------------ Yahoo! Groups Sponsor --------------------~--> 
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/zCsqlB/TM
--------------------------------------------------------------------~-> 

Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED]

Ikuti juga forum diskusi VB.net dengan 
mengirim email kosong ke [EMAIL PROTECTED]
 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/indoprog-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/
 


Kirim email ke