Geeks With Blogs
Razi Syed Professional Developer April 2008 Entries
How to append to a sql text data type feild
If you want to concatenate (append to end) a string to a field in SQL, there is a very easy and simple update statement for that: Update [tableName] Set [myField] = [myField] + 'whatever' Where [id] = 1 The + operator works fine for strings, as long as the field is varchar or nvarchar data type. If it is text or ntext, you cannot use the + operator to join strings, and you will get the follow sql error: "Invalid operator for data type. Operator equals add, type equals text" Which is pretty annoying. ......

Posted On Friday, April 25, 2008 5:29 PM

Copyright © razisyed | Powered by: