Rabu, 30 November 2016

Query split SQL Server

SELECT handphone,NO_TELP_KONTAK_DARURAT,
    PARSENAME(REPLACE(handphone,',','.'),2) 'Hp' ,
    PARSENAME(REPLACE(NO_TELP_KONTAK_DARURAT,',','.'),1) 'Telp'
FROM spg_pegawai