This was asked a few weeks ago on the SQL list ... here is the thread ...
http://www.houseoffusion.com/cf_lists/index.cfm?method=messages&threadid=256
&forumid=6&refresh=0
Dan
-Original Message-
From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 12, 2
You could do it in SQL Server with a stored procedure and a cursor, although
all things considered, it's probably faster and easier to do it in cf...
I've thought about or wanted to do this myself on a number of occasions, but
never been able to find a way to do it that wasn't way more effort than
Ahh... so I was wrong... :) there's COALLESCE() in SQL Server and apparently
somebody created a function to do it in Oracle... awesome... wonder if it
merits changes to my cms data structure...
> This was asked a few weeks ago on the SQL list ... here is the thread ...
> http://www.houseoffusion
3 matches
Mail list logo