Re: Simple (?) SQL Query.

Posted in 1995

Joey Duhon — Wed, 3 May 1995 16:43:49 GMT — source: Informix-list mailing list archive (1991-1998)

In article <3o6oke$1kp$1@mhafc.production.compuserve.com>, Trevor K Staats <100355.122@CompuServe.COM> wrote: >> In Melbourne our telephone numbers will soon change from >> (03)xxx-xxxx to (039)xxx-xxxx format. We have thousands of these >> update site set phone=????>> The ???? is where I am still stumped. >> Any ideas? update site set phone = phone[1,3] || "9" || phone[4,11] this will work with SQL, unless your engine is pre-5?, then you will have to use a program product.