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.
