...in the Advanced tab) supports "contains" queries where a substring like "07-186" works. Thanks again. "Diane Poremsky ...doesn't support wildcards. Instant search doesn't do substrings - it does leading searches. I think - is a ... are) , so it will search for 234 substring but you can't search for "0-234"...> I need to search a substring - "01-234" so that emails containing "...
Outlook doesn't support wildcards. Instant search doesn't do substrings - it does leading searches. I think - is a delimiter (. and : are) , so it will search for 234 substring but you can't search for "0-234" except using Advanced find's ...> "David Outlook Newbie" wrote: I need to search a substring - "01-234" so that emails containing "S01-234" or "T01-...
"David Outlook Newbie" wrote: I need to search a substring - "01-234" so that emails containing "S01-234" or "T01-234" or just plain "01-234" can be located easily. How can I do that, please? Sorry - I just got Office 2007 which includes Outlook. And yes, I have tried Advanced Find (control-shift-F) but with trial and errors I found inconsistent behavior - for example, ...
.../default.mspx or point your newsreader to msnews.microsoft.com. "David Outlook Newbie" <David Outlook Newbie@discussions.microsoft.com> wrote in message news:0F173BB6-2E9B-4D6F-AE81-4E701BA552B3@microsoft.com... I need to search a substring - "01-234" so that emails containing "S01-234" or "T01-234" or just plain "01-234" can be located easily. How can I do that, please?
I need to search a substring - "01-234" so that emails containing "S01-234" or "T01-234" or just plain "01-234" can be located easily. How can I do that, please?
... The numbers in the tariff table are strings, just numbers. The tariff table has numbers in it like "0871", or "079523". They're not all the same length so "LEFT" and "SUBSTR" and the like aren't easily used.. And the calls table has telephone numbers like "01234566789", "0871233454". SELECT Numbers.number, Tariffs.code ; FROM Numbers LEFT ...
But how can I do that when the substring is of variable length? In article <ekAGyA1EJHA.1280@TK2MSFTNGP02.phx.gbl>, Swdev2 wrote: RushMore is Your Friend. Make an index that matchs whats forming in the substring. then do another query based on that substring.
... The numbers in the tariff table are strings, just numbers. The tariff table has numbers in it like "0871", or "079523". They're not all the same length so "LEFT" and "SUBSTR" and the like aren't easily used.. And the calls table has telephone numbers like "01234566789", "0871233454". SELECT Numbers.number, Tariffs.code ; FROM Numbers LEFT OUTER JOIN Tariffs ON ...
...re all strings. Telephone numbers, numerics only, not that it matters I think. The numbers in the tariff table are strings, just numbers. The tariff table has numbers in it like "0871", or "079523". They're not all the same length so "LEFT" and "SUBSTR" and the like aren't easily used.. And the calls table has telephone numbers like "01234566789", "0871233454". Regards Mark
