>Thanks,
>
>pointed me in the right direction.
>
>CREATE SQL VIEW "lvSCHOOLS" AS;
>SELECT code_a.ccodedesc as cschooldesc, code_b.ccodedesc as cschoolcntry,;
>SCHOOLS.cmajor, DTOC(SCHOOLS.daward) as cdaward, ......
>
>DTOC is based on the underlying data in the table and does not consistently return the same length? Not sure but removing this field ended the problem so im fairly sure you were correct. I would probably have ensure i was geting a correct result or SPACE(10) in an IIF statement to force this to work..


Hi Mike,

The result of DTOC() function could be 8 character long if SET CENTURY is OFF somehow.