>Dear Sir, > >I have a string as > >Global Traders (pvt) Ltd. > >I want to replace it with > >Global Traders (Pvt) Ltd. && word Pvt must in proper case > >When I apply proper(), it does not work due to brackets. > > >Please help
I understand that this ago cry, but write a true solution it require very more code:
ss="Global Traders (pvt) Ltd."* you can use 9,10,11,12,13,32,160 to translate a prefix char to a proper prefix char* if char(11) it is out of data domain
? CHRTRAN(PROPER(CHRTRAN(m.ss,'(',CHR(11))),CHR(11),'(')