Home Forums SQL Server 2008 SQL Server 2008 - General A little help needed with simple Custom Function RE: A little help needed with simple Custom Function

  • July 11, 2013 at 9:30 am

    #1631644

    The problem is you're using double quotes instead of single quotes.

    However, you should really avoid doing a simple replace with a UDF as it will degrade performance in a horrible way.

    Why can't you ise the following? How dirty is the data you're receiving? With more details we could offer better help.

    SELECT REPLACE(FieldName, ', * *', ''),

    Field2,

    Field3

    FROM SomeTable

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2