Good Morning Laurenz,
That worked perfectly.
Thank You
Jeff
_
Jeffrey Schade
Systems Consultant, Technology Engineering
ISO
545 Washington Boulevard
Jersey City, NJ 07310
Voice: (201) 469-3738
FAX: (201) 748-1500
jsch...@iso.com
-Original Messag
Jeffrey Schade wrote:
> We have a table which contains a 3 byte column with datatype CHAR(3) which we
> want to redefine within
> the view as a CHAR(1) column and a CHAR(2) column. When I code the SUBSTR
> function the resulting
> column datatype is TEXT. I would like to see the CHAR datatype, is
We have a table which contains a 3 byte column with datatype CHAR(3)
which we want to redefine within the view as a CHAR(1) column and a
CHAR(2) column. When I code the SUBSTR function the resulting column
datatype is TEXT. I would like to see the CHAR datatype, is there
anything I can do to set th
We have a table which contains a 3 byte column with datatype CHAR(3)
which we want to redefine within the view as a CHAR(1) column and a
CHAR(2) column. When I code the SUBSTR function the resulting column
datatype is TEXT. I would like to see the CHAR datatype, is there
anything I can do to set th
