Find & Replace text thru SQL

[paragvshah]

Friends,

I want to know what function is there in MS-ACCESS 2000 to Find & Replace a text in a SQL statement written on asp page. Please let me know asap.

Parag.

 

[Guest_imported]

hey,
you should try to UPDATE tablename SET columnname = newvalue WHERE .....

the find criteria would go int the where condition.
hope this helps =)