User defined Variables

[Kailash R]

 I was wondering if there is a way to increase the size of user defined
variables ? I am not able to attribute a type to them and when I assign @sql
= 'a_text _field' , 'a_text_field' gets truncated if it exceeds the size of
@sql. This is not wholesome as I am using @sql in a subsequent prepare
statement and my procedure errors out with a sql syntax error. Any advice
for this would help.

thanks.