N nesli New member Local time Today, 02:57 Joined Jun 10, 2010 Messages 1 May 18, 2011 #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?
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?
P PeterF Registered User. Local time Today, 11:57 Joined Jun 6, 2006 Messages 295 May 18, 2011 #2 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.
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.