Re: Maximum number of TEXT columns ?

Ian Ilsley writes: |> |> --- |> |> Does anyone know if there is a limit with the number of text columns one |> |> can have in a single table. ? There is no limit on the number of columns of ANY type, but the max row length is 32K, which effectively limits the number of columns based on the length of the columns (e.g. you could have 1 32K column, or 32 1K columns, etc.). Dave Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney