[SQL] Re: Timestamp without time zone

2001-06-14 Thread Vivek Khera
> "PS" == Pasi Salminen <[EMAIL PROTECTED]> writes: PS> I am trying to create table with a field which type is timestamp PS> and I don't want it to be timestamp with time zone. This question has been asked at least 4 times since I've been following this list, including once by me. Appaarent

[SQL] search/replace in update

2001-06-14 Thread Gary Stainburn
Hi all, here in England OFTEL, the governing body for all things telephone recent hand another phone number dialing code change (one of many). This means that e.g. all mobile numbers that used to start 0589 now start 07889. Is there a way in SQL to update the phone number in-place? -- Gary S