Hi DougChar So I reckon this is a pretty stale thread by now, but I just found a way around what I think you were looking for (and I certainly was): So we know that the separator has to be a simple character string - so let's create a line feed character using BYTE(10). But we need something in quotes, so just stick the function into a %SYSFUNC() structure like this SELECT rpt_name INTO :good SEPARATED BY "%sysfunc(byte(10))" FROM daily_rpt_status WHERE rpt_status= 1; Obviously this is just Line Feed = BYTE(10) for *nix systems - for Windows you need Carriage Return = BYTE(13) as well - "%sysfunc(byte(13))%sysfunc(byte(10))" . Better late than never! :smileygrin:
... View more
