>Maybe you have some order involved?
>
>UPDATE YourTable SET dc_crdno = REPLICATE("*",12) + RIGHT(ALLTRIM(dc_crdno),4)) WHERE NOT EMPTY(dc_crdno)
>This also didn't work :( I still see 12 * in the report.
May be I need to check the report as well and browse the table after replace to see what's going on.
If it's not broken, fix it until it is.
My Blog 
