George Nicholson wrote:
Type conversion failure (which you aren't getting at the moment)
would be
trying to put text into a numerical field, etc., (but not vice
versa). Or
trying to put 1,000,000 into a field defined as Integer (max value of

32,767).

I think you should review this whole paragraph e.g.

CREATE TABLE TEST (
text_col VARCHAR(10),
int_col INTEGER)
;
INSERT INTO TEST (text_col, int_col)
VALUES (1000000,1000000)
;
INSERT INTO TEST (text_col, int_col)
VALUES ('1000000','1000000')
;

The above generates no errors for me.

Jamie.

--