Syntax error when attempting case sensitive SELECT in Access

Asked Dec 04 '19 at 12:07

Active Dec 04 '19 at 12:16

Viewed 33 times

Per this question, I've tried to perform a case-sensitive SELECT query on a column in my table, but it's returning a Syntax Error. The query is:

SELECT [EntityValueID] 
FROM [EntityValue] 
WHERE [EntityCode] = "&oK;" COLLATE SQL_Latin1_General_CP1_CS_AS

I'm not sure what I've missed here - is there something I need to download to get collation working? Or is it something apparently obvious? It highlights the COLLATE keyword when I attempt to run the query, so I guess the error is here, but it seems just like the answer I referenced.

edited Dec 04 '19 at 12:16

marc_s

704,970
168
1,303
1,425

asked Dec 04 '19 at 12:07

Lou

1,857
1
24
57

2

I don't think MS Access supports `COLLATE`. – Gordon Linoff Dec 04 '19 at 12:09
Ah ... then I guess my question is, how can I perform a case-sensitive SELECT in Access. – Lou Dec 04 '19 at 12:10
@Andre Yes it does, thank you. I just found that solution too. – Lou Dec 04 '19 at 12:14
1

or an alternative: https://stackoverflow.com/questions/33277646/case-sensitive-searching-in-ms-access – Andre Dec 04 '19 at 12:15

Syntax error when attempting case sensitive SELECT in Access

0 Answers0