Select from excel with replace function .net 2

Question

Hi all,
I need to select replace(X,oldvalue,newvalue) from tbl.
I get error message that replace function is not recognize.
I  use oledbcommand.
with .net 2.
how can I use replace,substring function.
Thanks.