K
Katherine Pacheco
Guest
I am trying to replace a NULL date with a blank. I end up with invalid date string. Ive Tried COALESCE, ISNULL, IFNULL, CASE STATEMENTS and nothing seems to work. I am querying a LINKED PROGRESS ODBC connection and using
declare @Data varchar(max)
set @Data= N'
SELECT MyCode
FROM TABLE
'
exec (@Data ) AT PROGRESS;
Ive done this many times before, I can do ISNULL, COALESCE etc just fine on all my other fields, but not the case with this Date field. Any help is greatly appreciated
Continue reading...
declare @Data varchar(max)
set @Data= N'
SELECT MyCode
FROM TABLE
'
exec (@Data ) AT PROGRESS;
Ive done this many times before, I can do ISNULL, COALESCE etc just fine on all my other fields, but not the case with this Date field. Any help is greatly appreciated
Continue reading...