Re: How to delete a record with the key which contains "%20"(space) in the

Hi David. How about the following, if you are using IDS 7.3+. update table_a set col1 = trim(trailing ' ' from col1) You need test your env. Regards. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: "David" <david@nortelnetworks.com> >Reply-To: "David" <david@nortelnetworks.com> >To: informix-list@iiug.org >Subject: How to delete a record with the key which contains "%20"(space) in >the front? >Date: Mon, 26 May 2003 18:29:34 -0400 > >When adding record, there are a lot of cases that user accidently add space >sign "%20" in the front or end of the key. > >Let's say: > >Key is defined as "name". > >When the user put " Kerry" or "Kerry " as key and create this record, it >will cause Database error when the second guy adds "Kerry"(No spaces) > >What SQL syntax will make sure deleting " Kerry" and "Kerry " safely? Thx > > > > > _________________________________________________________________ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail