var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: replace T-SQL fonction
I would like to know how to use a replace fonction on a table
Like, currently, the syntax for replace is
but I would like to do something more like
SELECT REPLACE ((SELECT * FROM TABLE1) , 'cde', 'xxx')
Thanks to reply!
Re: replace T-SQL fonction
I've found my problem ... which was in fact simple
select replace (FieldName , 'abc' , 'xxx') from MyTable...
the problem was that my FieldName was a Text field... which doesn't work... you need a varchar or nvarchar there...
select replace (CAST(FieldName AS varchar(8000)), 'abc', 'xxx') from myTable
You should consider changing your fieldtype to VARCHAR if TEXT is not required. It will make coding easier and improve efficiency.