Mungkin begini : select Nilai_huruf = (case nilai when 4 then 'A', when 3 then 'B' when 2 then 'C' when 1 then 'D' else 'E' end)
--- In [email protected], pemuda <[EMAIL PROTECTED]> wrote: > 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/
