If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
# in select queries
I want to find address records with # in the street field (i.e., 123 Easy St
#123). The problem is # is a wild character for numeric values. How can I write an expression to find records with # characters in them? |
#2
|
|||
|
|||
On Wed, 18 Aug 2004 20:54:57 -0500, "Hal Pratt"
wrote: I want to find address records with # in the street field (i.e., 123 Easy St #123). The problem is # is a wild character for numeric values. How can I write an expression to find records with # characters in them? Putting special characters in square brackets "insulates" them and causes them to be interpreted literally rather than as a wildcard: LIKE "*[#]*" should work. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Best way to find people on ALL lists. | Anne Savage | Running & Setting Up Queries | 3 | August 5th, 2004 07:24 PM |
Combining multiple select queries into one select | Andrea | Running & Setting Up Queries | 1 | August 4th, 2004 03:37 AM |
UNION query question | Dale Peart | Running & Setting Up Queries | 6 | July 14th, 2004 12:26 AM |
combining tables and linking records with queries | Dale Peart | Running & Setting Up Queries | 2 | July 9th, 2004 11:36 PM |
error in excel help. how to select a cell after clicking the Select All button? | Dmitriy Kopnichev | Links and Linking | 3 | December 5th, 2003 10:32 PM |