Another SQL statement question...

[river]

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?



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists