Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Concatenating a string with a text field
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00417687
Message ID:
00417693
Views:
20
I have found it although is there any way to determine how big the text field so i can get an accurate varchar size..if this is not the right way please correct

Code example
declare @NewText varchar(200)
set @newText = 'Reversed by : OSL,OSL'
update journals_reversals set details = RTRIM(LTRIM(@NewText)) + CHAR(13) + RTRIM(LTRIM(convert(varchar(1000),details)))
select details from journals_reversals



>I'm trying to add a string to a text field and it keeps telling me that......
>
>Server: Msg 403, Level 16, State 1, Line 1
>Invalid operator for data type. Operator equals add, type equals text.
>
>
>Code
>update journals_reversals set details = 'blah..' + details
>
>TIA
>Shawn
Shawn Dorion
Geo Sektor Dot Com
Website: http://www.geosektor.com

Web Hosting Plans
Visit : http://WebHosting.Applications4u.com/
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform