SQL ALTER TABLE Question

[Guest]

Hi,

I'm fine changing the field type on a single field using the following sql:

ALTER TABLE #TP#_TemporaryTable
ALTER COLUMN Price double

I need to change multiple field types, can this be done in a single sql statement. I've tried

ALTER TABLE #TP#_TemporaryTable
ALTER COLUMN Price double
ALTER COLUMN UPC double

and a few others, but no luck. Is it possible to do this?

Thanks!

cfwild

[-__cfSearching__-]

I imagine that would depend entirely on which database you are using. My guess would be no, but your best bet is to check the documentation for whatever database you are using.

[Guest]

Database is MS Access.

cfw

[-__cfSearching__-]

I tend to doubt MS Access would suppport it. But I am more familiar with other databases, than MS Access. So again your best bet is to check the MS Access documentation.