Advanced text search

2003-08-14 Thread Rudi Ahlers
My statement is as follows: select compid,company,phone from companies where (phone=+27-21-*); And it doesn't return any records. What am I doing wrong? Kind Regards Rudi Ahlers +27(82) 926 1689 The basic difference between an ordinary man and a warrior is that a warrior takes everything

Re: Multiple field updates

2003-08-14 Thread Rudi Ahlers
Great thanx, this one worked wonders Kind Regards Rudi Ahlers +27(82) 926 1689 The basic difference between an ordinary man and a warrior is that a warrior takes everything as a challenge while an ordinary man takes everything either as a blessing or a curse. - Original Message - From

Multiple field updates

2003-08-12 Thread Rudi Ahlers
Hi Can someone please tell me howto update a field (which is auto_increment) for a range from say 4000 - 8000? I only want to change info for listings in that range, if my database has about 75000 listings Kind Regards Rudi Ahlers Océ Software Support +27 (11) 661-9000 The basic difference