Re: Please can you tell me what function get a piece of text from another text?

Manuel Gallego Huertas <cc0gahum@lucano.uco.es> wrote: >... using UPDATE command the problem is >that I don't know what is the function to get a piece of text from >another text. You can use substring references [from,to]. They can be used in both the target and source field. Examples: update tablename set field1 = field2[4,6] where ... update tablename set field1[3,4] = "XX" where ... Catalin -- ========================================================================= Catalin Badea _/_/_/ _/_/_/ _/_/_/ _/_/_/ _/ _/ _/_/_/ _/ _/ _/ _/ _/_/ _/ Senior Technical Architect _/ _/_/ _/ _/_/_/ _/ _/_/_/ _/ _/ _/ _/ _/ _/ Tecsys Inc. _/ _/_/_/ _/_/_/ _/_/_/ _/ _/_/_/ ===== cat@tecsys.com =========== include system "disclaimer.4gh" ===== == http://www.virtualmarketplace.com/LEVEL3/ITEC/TECSYSE/TECSYSE.HP ===