Missing Operator in Query

[Hfnet]

I have an SQL sleect statement which is bringing up an error:

Set adoRec = CurrentDb.OpenRecordset("" & _
"SELECT CustomerAddresses.TechRef, CustomerAddresses.CustomerName, UCase(CustName) " & _
"FROM CustomerAddresses " & _
"WHERE (UCase(CustName)) = " & dID)

The error is
Synatx Error (Missing operator) in Query Expression
'(Ucase(CustName) = TEST NAME'.

Any ideas please? I need to convert a search name to upper case for matching.

 

[RoyVidar]

Text/strings will need to be qualified thru single quotes:

[tt]"WHERE (UCase(CustName)) = '" & dID & "'")[/tt]

Roy-Vidar

 

[Hfnet]

Thanks!