Hello... When using INSERT processing without SELECT, the date format is taken from the user's profile. When using INSERT processing with SELECT, SQL assumes the value is for output and provides it to Query Management in the SAA format (ddmmyyyy). See the <a href="http://publib.boulder.ibm.com/iseries/v5r1/ic2924/index.htm?info/qmp/rbaromst288.htm">iSeries website</a> for further information... Hope this helps... ================================================================ Edit codes are not part of SQL column definitions. QM queries are SQL processes. Edit codes associated with file fields are not even seen. In short, your edit codes have no connection to what you're doing. If you need editing, specify it in the column edit in the QM form used for the query. Tom

Hello... When using INSERT processing without SELECT, the date format is taken from the user's profile. When using INSERT processing with SELECT, SQL assumes the value is for output and provides it to Query Management in the SAA format (ddmmyyyy). See the <a href="http://publib.boulder.ibm.com/iseries/v5r1/ic2924/index.htm?info/qmp/rbaromst288.htm">iSeries website</a> for further information... Hope this helps... ================================================================ Edit codes are not part of SQL column definitions. QM queries are SQL processes. Edit codes associated with file fields are not even seen. In short, your edit codes have no connection to what you're doing. If you need editing, specify it in the column edit in the QM form used for the query. Tom