In most sql languages (specifically T-SQL from SQL Server) ISNULL is equivalent to the base COALESCE function.
Two differences:
COALESCE is ANSI-92 standard
COALESCE is really in the form:
coalesce(
a1, a2[, a3, ...]
)
which means it takes at minimum two arguments and can have as many arguments as
the implementation allows.
- dave
Mike Kelp wrote:
It is my understanding that anytime SQL server can not return records
you will end up with a null, though the ISNULL *( */check/*_*/expression
/*,* /replacement_value /*) *function would work well for solving your
problem...See doc here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_adda_9tbk.asp
Hope this helps,
Mike.
On 7/21/06, *Tim Starling* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
I was under the impression that
<cfquery name="qMyquery" datasource="#dsn#">
SELECT COALESCE(sum(mytable.Amount),0) AS myAmount
FROM etc,…
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/
