UPPER in OleDb

[albertkhor]

SQL = "SELECT Location FROM PropertyLocation WHERE UPPER(PropertyLocation_Desc) = '" & location.ToUpper & "'"

When i try to execute error msgbox pop up: Undefined function 'UPPER' in expression. Is that because UPPER cannot use in Oledb?

 

[kulrom]

Look, i am not very sure that Jet supports UPPER function at all ... but this is not final ... btw, do you have SQL Server on the same coumputer?

 

[albertkhor]

Look, i am not very sure that Jet supports UPPER function at all ... but this is not final ... btw, do you have SQL Server on the same coumputer?

Hi kulrom:
thx for reply me. i'm using Microsoft.Jet.OLEDB.4.0; no Server just connect to .mdb!