var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: adding to text
If I have a varchar field, I can easily add to it. For instance
select 'Name: ' + fname as fname from Customers.
But what if I have a text field instead of varchar?
select 'Summary: ' + summary as Summary from Customers won´t work at all.
Is there a way to accomplish this?
TEXT columns really ought to be manipulated on the client, not the server. There are a number of reasons for this, most of which are design and performance issues.
If you really must manipulate a TEXT column on the server, you can use the UPDATETEXT statment, but I'll forewarn you that it is rather ugly.
You really ought to handle this on the client if you can't make the column a VARCHAR instead of a TEXT column.