>Hi everybody,
>
>I have a program, which converts old legacy files into BldMstr like files. It does it by doing some select statements. Now, I've checked the files and I found some garbage records in them along with the normal records. These garbage like records contain || symbols in most of the fields (chr(13)). My question is: how can I get rid of these records programmatically during select statement?
>
>Thanks a lot in advance.

Something like this :

lcBad=''
for ix=0 to 31
 lcBad=lcBad+chr(ix)
endfor

lcChkExpr = 'MyCharField1+myCharField2'
select * from myTable ;
 where !empty(chrTran(eval(lcChkExpr),chrtran(eval(lcChkExpr),lcBad,''),'')) ;
 into cursor crsBad

Cetin