Re: spaces

Posted in 2006

Jonathan Leffler — Thu, 21 Sep 2006 03:46:54 GMT — source: Usenet: comp.databases.informix

Fotopoulos Lefteris wrote: > I'm trying to fill a string with spaces: > > SELECT RPAD('Where are you', 18, ' ') > FROM mytable > > But I want to use the character code for space which is 32. > Anyone knows the function to call in order to print 'space'? SELECT 'Where are you'::CHAR(18) FROM mytable; CHAR columns are automatically blank padded. I'm assuming you're using IDS 9.x or 10.x; please include version info. (Is that the third message today I've sent with 'version info please'?) -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/