Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Concatenating a string with a text field
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
00417687
Message ID:
00417693
Vues:
18
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/
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform