Replace function in vb6 with MS Access using adodb.recordset

[Tufail Ahmad]

In vb 6.0 with MS Access using adodb.recordset the below sql statement gives error help please dim sql as string sql="Select * from table1 Where Replace(Field1,".","")=" & tokenID set rs=cn.execute(sql) Error: Unknown function Replace is used although the above sql statement works fine in MS Access query

[Luc Pattyn]

IMO your problem is with the string literals inside the Replace call; try doubling the double quotes in there. :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

---

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

---