Cathy,
You can use < pre> < /pre> tags (w/o spaces) to preserve code formatting, include HTML/XML tags, e.t.c.
>The statement is invalid as written. Try this:
>SELECT x, ;
> y, ;
> z, ;
> PADR(IIF( LEN(ALLTRIM(field1)) < 30, Field1, ''), 29) AS ThinField, ;
> PADR(IIF( LEN(ALLTRIM(field1)) >= 30, Field1, ''), 100) AS FatField ;
> INTO CURSOR csrPrintcsr
>(The UT wouldn't let me use greater or less than signs!)
>
>However .... I have to ask why you are trying to do this? I don't think this is what you need to do to solve your original question. You don't need to put the field into two separate fields in the cursor. The same field can be put on the report twice.
>
>Just use the original table with one field and put two field objects on the report. For the first object, use Field1 as the expression, and use LEN(ALLTRIM(field1)) (less than sign) 30 as the Print When logic. For the second object, use Field1 as the expression, and use LEN(ALLTRIM(field1))(greater than or equal to sign) 30 as the Print When logic.
--sb--