How to Use Concatenation and Conversion SQL Server 6.5
I have a SQL Server 6.5 database I'm trying to update. I have a table called P_Notes and a column within that table called PN_P_Notes. I want to add a note to the already exsisting notes. Here is the query I am trying.
UPDATE P_Notes PN
SET PN.PN_P_Notes = 'This is a test!' + PN.PN_P_Notes
This is the error message I receive:
The data types varchar and text are incompatible in the add operator.
My column PN_Notes is the text data type. So that makes the data I'm trying to add the varchar.
I guess I'm not sure on how to convert 'This is a test!' to text.
Please help. I'm sure this is somewhat simple. Thanks.
Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.