pertemuan ke 6

create Database KARAKTER
Use KARAKTER

Create Table TBLKARAKTER
(Kode Char(8))

select * From TBLKARAKTER
Insert Into TBLKARAKTER Values('ST/K/L/1')
Insert Into TBLKARAKTER Values('AD/B/L/0')
Insert Into TBLKARAKTER Values('AC/K/P/3')
Insert Into TBLKARAKTER Values('ST/B/P/0')
Insert Into TBLKARAKTER Values('AD/K/L/1')
Insert Into TBLKARAKTER Values('AD/K/L/2')

Select * From TBLKARAKTER

Select LEFT(Kode,2) As Kiri From TBLKARAKTER
Select RIGHT(Kode,1) As Kanan From TBLKARAKTER
Select Substring(Kode,4,1) As Tengah From TBLKARAKTER

//Rumus Melihat Tampilan Penuh.
Select Kode, LEFT(Kode,2) As kiri, RIGHT(Kode,1) As Kanan ,
SubString(Kode,4,1) As Tengah From TBLKARAKTER

--Menambahkan,,,,,
--Rumus untuk melihat Kode Pegawai & Kode Status:
select Kode As [Kode pegawai],
SUBSTRING(Kode,4,1) As [Kode Status] From TBLKARAKTER

---contoh Gabungan Fungsi String Dan Case
--Cara 1
Select LEFT(kode,2) AS "Kode Jabatan",
case when LEFT(Kode,2)='ST' then 'Staff'
when LEFT(Kode,2)='AC' then 'Accounting'
when LEFT(Kode,2)='AD' then 'ADM'
else null end Jabatan
From TBLKARAKTER
Gambar Cara 1

Cara 2
Select LEFT(Kode,2) AS "Kode Jabatan",
case LEFT(Kode,2)
when 'ST' then 'Staff'
when 'AC' then 'Accounting'
when 'AD' then 'ADM'
else null end As Jabatan
From TBLKARAKTER
Gambar Cara 2