>Naomi,
>The declare statement does not work for me. I am running straight VFP 9 without the SPs, could that be the reason?
>
>Calvin
How exactly you're trying it, can you show some code? Also, what is your driver used in connection string?
Try for tests now
declare @T table(test varchar(max))
insert into @T ('Test')
select * from @T
If it's not broken, fix it until it is.
My Blog