Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    India
    Posts
    109

    Unanswered: Replace function not working

    Hi,
    I posted a request here and am still working on it when I landed on this bug.

    Code:
    select top 10 replace(comma_separated_string,',','giveaverylongpassagehere') from table

    The function works fine if the comma separated string is small or if the passage is small. It fails for long passages..

    Is this a mssql bug?

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    What's long? Replace works fine for me on 8000. Does it break off at 1024 in the Analyzer, while it's len(..) says otherwise?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •