Re: Simple SQL problem

Posted in 1998

Jonathan Leffler — Tue, 2 Jun 1998 09:26:09 -0700 — source: Informix-list mailing list archive (1991-1998)

Jamie Nash <jnash@protek.co.uk> asked: >How can I [...] 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' Addition is defined as a numeric operation. The string concatenation operator is ||. Hence: UPDATE Users SET Password = Password || 'XX' WHERE Username = 'FRED' Yours, Jonathan Leffler (jleffler@informix.com) #include <disclaimer.h>