[Stackoverflow] [Progress OpenEdge ABL] SQL / PROGRESS Blank in place of NULL Date

Status
Not open for further replies.
K

Katherine Pacheco

Guest
#1
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...
 
Status
Not open for further replies.
Top