title: Need to convert Text field to Varchar temporarily so that I can pass to a stored procedure
body: <p>I am using a SQL 2000 database.</p>
  
  <p>I am working with a database in which I cannot change the types on the tables, or the stored procedures. One of the stored procedures I need to call expects a parameter of 'text'. I can get to the text field, but I am unable to figure out who to store that in a variable or any other way to pass it into the stored procedure?</p>
  
  <p>If I try and create a text variable, SQL won't let me - if I convert it to varchar I only get the first character from the text field. </p>
  
  <p>Any tricks to get around this much appreciated! Thank you!</p>