Ok, I've been trying to find something, on-and-off for two days, and can't. Here is what I have. Say I have a table called "changeme", with one varchar(30) field called "field01". I want to replace all occurances of the substring "Fpdd", in field01, but it doesn't appear in the same location in all records. How do I do it? Here is some sample data (none of it is real data).

Thanks all!

==========================
AjlMxjyqbeTI
bGLSQGqLFpdd <---- The string is here
BhXbtmAdeJNk
BljxEwpIGgEA
cJdDpOUAIDNw
HchGWSxOWepN
hMhFWDTxqSZr
hVftrnMCcPLh
iJysbwSBnBfy
iVmKJkHLWLxw
KBNNdlRXvXXv
KIaFpddQAsTW <---- The string is here
MlkoBuTsfwEB
MLwDxkUDNqeA
MndCJUsAvglg
FpdddZNYpFEW <---- The string is here
nJobAfmJWnac
nPlOyjyYGUFA
OBbTkjfrRMtA
pbSjvshyRAIU
QRdJrtFDRrep
qWXNbcLKbTJU
rUNZPCsRaqRY
sjwfTdWwcWmx
uZhRIyDKMUgA
vjxADNrovKwS
XCbFpdddiBIr <---- The string is here
XfgJQRoyNVwp
xjOHJAcjAYNY
XtnfdZsQVeiP