http://livedocs.adobe.com/ Macromedia LiveDocs - online documentation with user feedback. Copyright 2009, Macromedia, Inc. 2009-11-25T13:50:40 en-us http://livedocs.adobe.com/coldfusion/7/htmldocs/00000601.htm#39252 Starting with ColdFusion MX 7, you cannot add a string literal (for example, "All") to a column that is of type numeric. This was allowed in previous versions of ColdFusion MX. Starting with ColdFusion MX 7, the QuerySetCell function performs type validation. ASandstrom 0 1 2005-09-07T10:58:34 http://livedocs.adobe.com/coldfusion/7/htmldocs/00000601.htm#37715 As far as I know, CFML doesn't support the SQL NULL (i.e. three-value-logic). Database fields that are NULL are returned in CFML as empty strings. <br> <br>Note that <cfqueryparam> and <cfprocparam> do have provisions to set a SQL NULL when updating a database.<br> <br>FWIW, QuerySetCell(query, column, "", CurrentRow) seems to work for me on a SQLServer timestamp on CF7. jrunrandy 1 0 2005-07-20T13:46:45