how about
SELECT TextID, IFNULL(TextColumn1, '') + IFNULL(TextColumn2, '') AS
AllTextColumns
FROM Table1
-----Original Message-----
From: river [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 3:53 PM
To: CF-Talk
Subject: Another SQL statement question...
It's off-topic, but I know people here are experienced with SQL, so...
I am using SQL 7.0 and CF 4.5. I am trying to combine two ntext field
columns to one field in a query, but I have a problem when one of the fields
contains 'NULL' value. I am trying:
SELECT TextID, TextColumn1 + TextColumn2 AS AllTextColumns
FROM Table1
But when either TextColumn1 or TextColumn2 has the 'NULL' value, the
resulting column, AllTextColumns, shows as empty even if the other column
has a text string in it. Is there a way to prevent this?
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
