I am asking this for the third time cause i cant seem to get an answer to my problem<BR><BR>I am trying to figure out the command text for the READTEXT function. Before I always used the LEFT function which I had set up like so<BR><BR>SELECT LEFT(tbl_mytable.myfield,25) AS myfield<BR><BR>but that doesnt work on some types of fields in an SQL DB.<BR><BR>SO know i have to setup the same line using READTEXT. I have checked the MS hellp page but cannot figure out the syntax. can anyone help?<BR><BR>It has been suggested i use<BR><BR>SELECT LEFT(cast(tbl_mytable.myfield as varchar(255)), 25) AS myfield<BR><BR><BR>but this is just converting the field type. I should be able to use the READTEXT (tbl)mytable.myfield ???????