OleDb: Select

[albertkhor]

SELECT MobilePhone FROM tablePhone WHERE (REPLACE(Mobile_Tel1, '+', '')

why this statement cannot work in Microsoft.Jet.OleDb.4.0?
how to use replace in oledb?

 

[kulrom]

it is fully supported by Access (at least MSaccess 2003) but i am not sure that it is correctly implemented in your statement.

The syntax for the Replace function is:

Replace ( string1, find, replacement, [start, [count, [compare]]] ) [COLOR=green]'last three arguments are optional[/COLOR]

and it suppose to be used as it follows (actually it makes more sense if you do something like this):

SELECT MobilePhone FROM tablePhone WHERE Mobile_Tel1=REPLACE(Mobile_Tel1, '+', '')

HTH
Regards

 

[albertkhor]

it is fully supported by Access (at least MSaccess 2003) but i am not sure that it is correctly implemented in your statement.

The syntax for the Replace function is:

Replace ( string1, find, replacement, [start, [count, [compare]]] ) [COLOR=green]'last three arguments are optional[/COLOR]

and it suppose to be used as it follows (actually it makes more sense if you do something like this):

SELECT MobilePhone FROM tablePhone WHERE Mobile_Tel1=REPLACE(Mobile_Tel1, '+', '')

HTH
Regards

Below is my code but it cannot work, can you help me check what i did wrong?

SQL = "SELECT * FROM Contact [SIZE=2]WHERE Mobile_Tel1=(REPLACE(REPLACE(REPLACE(Mobile_Tel1, '+', ''), '-', ''), ' ', '') LIKE '%" & txtphone.Text & "%'"
[/SIZE]