Change format name with comma Change format name with comma TheLazyPig (Programmer) (OP) 22 Apr 21 02:34 Hi! How can I change Lastname;Firstname;mi to Lastname, Firstname mi? Thanks in advance. RE: Change format name with comma Andrzejek (Programmer) 23 Apr 21 12:17 If you have this data in your table: table: People Person Brown; Jack; X White; Susie; Q and you want to have: table: People Person Brown, Jack, X White, Susie, Q You can simply do: Update People Set Person = Replace(Person, ';', ',') Unless you want something completely different... ---- Andy "Hmm...they have the internet on computers now"--Homer Simpson RE: Change format name with comma carp (MIS) 23 Apr 21 23:37 If you want the first semicolon changed to a comma and the rest changed to a blank, I think this will do it. Full disclosure - not tested. CODE... substr(Person, 1, instr(person,';')- 1 )||', '||REPLACE(substr(person,instr(person,';')+1),';',' ') ... RE: Change format name with comma TheLazyPig (Programmer) (OP) 27 Apr 21 05:19 The code was working. Maybe the problem is where I run it. I'm running it on foxpro v9 but the tables I used is from an oracle db.