Using function to update text field

[ejgb]

I have a new system with more processers and have copied a database from my existing system.

On the existing system everything works fine, however on the new system any updates performed on fields with a datatype of text fail when the update text includes a call to a function that returns a varchar.

Any suggestions welcome.

E.Barlow

 

[ptheriault]

What is the error message it fails with. Can you post the function and how it's called?

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[ejgb]

The error message;

The query processor could not produce a query plan

An example update statement is;

update table1 set text_field = 'Hello World ' + dbo.fn_Return('12343234') where unique_id = 1

where dbo.fn_return returns a varchar data type.

Regards