Re: Simple SQL problem

Posted in 1998

Sunil Thakkar — Tue, 02 Jun 1998 09:24:53 CDT — source: Informix-list mailing list archive (1991-1998)

Jamie Wrote : How can I do the following, i.e. add some characters to data in a column???? The statement below will not work. (password is a CHAR field) update users set password=password+"XX" where username='FRED' ================================================================ simple Problem = Simple Solution. update users set password=trim(password) || "XX" where username='FRED' This will help. ____________________________________________________________ Sunil Thakkar (sunil0@hotmail.com) Informix DBA Last seen: Consulting at US-AirForce, Texas. _____________________________________________________________ There is always a simple way of solving complicated problems. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com