November 21, 2005 at 9:24 am
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
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy