Re: PLEASE PLEASE PLEASE Help Me!!!

|> 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. {SNIP} |> Although I can check for this using SQL similar to: |> |> select keyfield from table |> where keyfield[1,4] = "1234" |> and keyfield[5,28] is null |> |> I cannot seem to use 4GL code to make similar locks which would be |> recognised by the 'other' package. Can't you move it to a VARCHAR(28) and select keyfield from table where keyfield[1,4] = "1234" and LENGTH(keyfield)=4;