sp + text to varchar

[vlitim]

I have a text field that I need to grab the first 255 characters and insert it into a varchar(255) field. Can someone please help me!

 

[Spellman]

You should be able to put a text field inside a varchar field using a simple insert or update statement. Use the left(textfieldname,255) function to get the first 255 characters from the text field. Mark

The key to immortality is to make a big impression in this life!!

 

[vlitim]

I have tried that but I get the error:

Argument data type text is invalid for argument 1 of left function

 

[plantj]

This works

convert(varchar(255),comment)