Re:

On Wed, 2003-10-01 at 11:19, Daniel Schuchardt wrote:
> But CAST(NULL AS VARCHAR) should make it a varchar

NULL is still null, whatever you cast it to.  The column type is
independent of whether one particular datum is null.

Instead of casting, you want COALESCE(field2, '') to give you an empty
string if the value is null.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK                             http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "Yet if any man suffer as a Christian, let him not be
      ashamed; but let him glorify God on this behalf."
                                        I Peter 4:16