Posted by imani_technology_spam@yahoo.com on 12/06/05 18:33
Is there a limit to how much text you can concatenate (other than data
type limits, of course)? For example, if you write:
SELECT 'This is some text from: ' + Convert(char(15), SomeFieldName01)
+ 'some more text' + Convert(char(25), SomeFieldName02) + 'yet more
text.' As BigNote
FROM Table
Is there a limit on how much you can concatenate into that big note
field, meaning is there a limit other than the size of the data type?
[Back to original message]
|