Can you use the trim function in the where clause? For example:
SELECT * from resv where trim(street) = 'Maple'.
The table may have like ' Maple' or 'Maple '.
Or maybe just
SELECT * frpm resv where street like '%Maple%'
Would that work?
The problem I see with that is I don't want a match of 'Maple Street'