I have an MS Access table with a text column called Company, and it
contains names like "Baca County", "Jefferson County", "Boulder County",
etc. What I want to do is write an Access SQL query to return the names as
"Baca", "Jefferson", "Boulder", etc.
I tried this:
SELECT LEFT(Company, SEARCH(" County", Company, 1)) as Name
FROM CCI_Contacts
WHERE Company LIKE "*County*";
and Access whines about an "undefined fucntion 'SEARCH' in expression,"
yet SEARCH() is a string function that returns a number and is documented
in the online help. Anyone know what's wrong with this?
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 15114
