Re: PLEASE PLEASE PLEASE Help Me!!!

tech (tech@compsys.demon.co.uk) wrote: : This one has got me baffled - can anybody please help me ... : I am using Informix v4.00 RDS, I4GL and ISQL. : Is there any way of assigning a NULL value to part of a column value ? : For example, I have a column in a database table which is 28 characters : long. I need to insert a value into the first 4 characters whilst : leaving the remaining 24 characters as NULL. ......... One way of having a "real" value in the first part of a column and having the rest undefined is to use the VARCHAR data type. If you insert a column with length of 4, the remaining 24 bytes are logically null. If your version of Informix doesn't support VARCHAR, then this won't help you too much. (and I have a funny feeling this is the case .... ) |-----------------------| O< ----------- DDI Systems Inc -----------| | timward@crl.com | \\_____| The opinions expressed are not | |Tim Ward < Data Duck > | \\>>> / necessarily mine, but those of my Employer| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~