I tried to declare a text variable as a local variable in a stored procedure but got an error msg saying I could not declare variables with type Text(somethin like that) so I declared them as Varchar.Problem is when i try to insert info it only takes one character the rest is discarded- because the varchar declared is not large enuf(I assume)<BR>is there a work around I need a data type large enuf to hold the size of a text variable