Bill

>Can anyone help me how can programmatically change a field type from memo to character

select ....., left(memofield,254) as charfield ;
   from OldTable
   into table NewTable

Change the 254 to whatever desired field with you are wanting to convert it to