Thanks, I got it to work.

My mistake was instead of this:

Select iif(ConvrtDate>0,000000+Responders,0) as Converted ...

I should have done this:

Select 000000+iif(ConvrtDate>0,Responders,0) as Converted ...

Aloha,

James
>Try

Select 000000 + myfield as newMyfield ...
>

>
>>Hi All,
>>
>>How do I control the column width for a numeric column in a SQL result set.
>>
>>I'm using the CrossTab foundation class and am getting an data overflow error. On one of the queries I did this:
>>
>>

>>Select 000001 as Mailed ...
>>

>>
>>and it fixed the problem. However now I need to use the data from a field. I tried expanding the field width but that didn't work.
>>
>>Thanks in advance for any help.
>>
>>Aloha,
>>
>>James