SQL Server Indonesia User Groups Community

sob..sy ada trouble..hehehe..kyknya trouble terus nih... 

client_code          company_name             address

abc1                    PT.ace                      jln.D

sel2                     PT.ask                      jln.A

bagaimana merubah PT.ace dan PT.ask itu menjadi ace, PT dan ask, PT

sy udah coba begini :

select
client_code,
replace(company_name,'PT.%','%, PT') as company_name,
address
from coba

tapi blm berhasil..any idea?? 

thanks..

 kok sepi bgt yaa... biasanya ada MR.hendrix yg jawab...hehehe...

halo bos,

sorry yah baru sempet buka sekarang.

dah coba kayak gini:
select
    client_code,
    replace(company_name,'PT.','') + ', PT' as company_name,
    address
from coba

 hehehe..bro hendrix..udah clear trouble nya dari forum sebelah...

thanx dah mau jawab...

select
client_code,
substring(company_name,4,len(company_name))+', PT' as company_name,
address
from
coba

 gt jawabannya..