>>What's the best way to parse a long SQL statement into a string variable?
>>
>>For example:
>>
>>cquery = "select mastddup.location, mastddup.census, ;
>>mastddup.name,mastddup.addr1, mastddup.city, mastddup.state, mastddup.zip,;
>>mastddup.zip4,bs_arch.location, bs_arch.mail_date,bs_arch.mail_code from mastddup,;
>>bs_arch where mastddup.location=bs_arch.location and bs_arch.mail_date >= '19981201' "
>>
>>The problem I've got with this particular string is the last "and" clause. I keep getting syntax errors.
>
>What are the values in BS_Arch.Mail_Date, is it equivalent to DTOS() format on the file or is it a date... If date, change to DTOS( bs_arch.mail_date ) >= '19981201'
If it is a date change the last part to:
bs_arch.mail_date >= {^1998/12/01}