I use the %char bif to create a "character" version of a date field. Example: Run = 'OPNQRYF FILE((COVMST)) + QRYSLT(''ISSUE *GE "' + %Char(Cutoff) + '"'')'. I know you could result into a character field. Let me know if this help you with the select statement. I have struggled with sql concats in the past.
Unconfigured Ad Widget
Collapse
Announcement
Collapse
No announcement yet.
concatenate a date field with other fields
Collapse
X
-
concatenate a date field with other fields
I am trying to display information on my screen using SQL. The statement reads: SELECT field1 || field2 || datefield from mylib/filea. I get an error message. field1 and field2 are character fields and datefield is an *ISO Date field. Is it possible to concatenate a Date field with other fields? Or how can I change the Date field to a character field? Thank You.
Comment