Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-27 : 10:17:10
|
| paul writes "I am interested in the right 50 chars of a text field of some 1000+ chars. I would like to store this to a variable and temporary table and perform a select distinct. How do I get around the fact that substring &c do not seem to work on text fields and that any conversion (CONVERT/CAST) only seems to allow a max of 255. I have tried using TEXTSIZE but that seems to be over-ridden by a system setting. At the moment I am using cursors to walk down the table and using READTEXT to select the last 50c. However, this does not seem to support assignment to another variable but just prints it to the screen. Do I need to perform some kind of low-level read or am I missing something?" |
|
|
|
|
|
text to char conversion