Hi, How to replace a string while retrieving data from an access database in ASP. NET. I wrote the query as Select replace(empname,"tt","mm") from employeetable; but its giving the error as undefined function pls do reply for this regards mijo thomas
Hi, How to replace a string while retrieving data from an access database in ASP. NET. I wrote the query as Select replace(empname,"tt","mm") from employeetable; but its giving the error as undefined function pls do reply for this regards mijo thomas
Select IIF([empname]='tt','mm',[empname)) as empname From employeetable; This will give you mm if the value of empname is 'tt'; otherwise it will give you empname. Hope that is what you are looking for :cool: Barbara
