I'm trying to query a table using the following criteria:
A string "Big Mac $1.95" needs to match a record "Big Mac"
Theoretically, I'd like to chop everything to the right of the blank
space before the $ sign on the string and then match it with the db
lookup. However, to my knowledge, VB doesn't have a good Chop
function. Perhaps I could feed the string into a character array or
I also tried kludging something using Like, but was unsucessful. But,
then again, I'm not a VB pro.
Thanks in advance,