Post reply

problem with REPLACE

  • November 21, 2005 at 9:24 am

    #166351

    I've been looking at the Replace Function to use within a stored procedure, I've one problem..... the example given in the help is :

    SELECT REPLACE('abcdefghicde','cde','xxx')

    it replaces each letter in the first string as specified in the second string with the x's, what do I need to do if I want the whole string 'cde' matched before it replaces anything, rather than any 'c' or 'd' or 'e'?

  • November 21, 2005 at 9:41 am

    #604996

    my appologies everyone, I've found my problem.. I was using a variable instead of 'cde' and I hadn't set the length

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply