Chane All columns to text from memo

[JR]

Subject basically says it all however I'm trying to change all existing
memo fields to text of 255 in length. Is there a single SQL query that
can be used for all of them?

Thanks.

JR

[Gabriele Bertolucci]

> Subject basically says it all however I'm trying to change all

existing memo fields to text of 255 in length. Is there a single SQL
query that can be used for all of them?

I suggest you to try using ADOX for recovering all memo fields.

Then here's the SQL statement to change the data type of found columns:

ALTER TABLE mytable ALTER COLUMN mycolumn TEXT(255)

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution