Well this is a bizarre bug, but it's a bug none the less.

When I filter notes by Location, and use a word beginning with 'b' (such as 'bridge'), I get the following SQL error:

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'webb_note_lookup.created'ridge%')) AND (webb_note_lookup.group_nid = 717) ORDER' at line 1 query: SELECT node.nid, webb_note_lookup.created AS webb_note_lookup_created_created, node.title AS node_title, node.changed AS node_changed, node.created AS node_created, node_data_field_character_name.field_character_name_value AS node_data_field_character_name_field_character_name_value, node_data_field_parent_note.field_parent_note_nid AS node_data_field_parent_note_field_parent_note_nid, webbtopic_topic.topic AS webbtopic_topic_topic FROM node node INNER JOIN webb_note_lookup webb_note_lookup ON node.nid = webb_note_lookup.nid LEFT JOIN webbtopic_topic webbtopic_topic ON node.vid = webbtopic_topic.vid LEFT JOIN content_type_note node_data_field_character_name ON node.vid = node_data_field_character_name.vid LEFT JOIN content_type_note node_data_field_parent_note ON node.vid = node_data_field_parent_note.vid WHERE (webb_note_lookup.created >= 1261371600 + -604800) AND (UPPER(webbtopic_topic.topic) LIKE UPPER(''webb_note_lookup.created'ridge%')) AND (webb_note_lookup.group_nid = 717) ORDER BY webb_note_lookup_created_created ASC in /usr/www/users/stfleet/webb/includes/database.mysqli.inc on line 156.

It does, however, work if I use a capital 'B' (e.g. 'Bridge').

Jack