find exponent ² via function chr(178)

nesli

New member
Local time
Today, 02:57
Joined
Jun 10, 2010
Messages
1
in my query i need to search and find the rows that contain ².
when i use the function chr(178), it lists the rows that contain ², but ALSO 2. i only want to list the rows that contain ². how can i specify this? :confused:
 
That's beacause Access standard way of comparing (database).

In your query create a field with:
Code:
Test²: InStr(1,[test],"²",0)
and filter for values > 0.

The last parameter of the "Instr" function makes the compare binary.
 

Users who are viewing this thread

Back
Top Bottom