Eddie,
You need to use the MID & Instr function to achive this. For example, to
extract Seattle from "Seattle, WA" you need to use following expression.
expr: Mid("Seattle, WA",1,InStr("Seattle, WA",",")-1)
Thanks.
Kiran
Eddie Van <[EMAIL PROTECTED]> wrote:
SELECT Table1.Field1, Left([Field1],InStr([Field1],",")-1) AS City
FROM Table1;
On 3/14/06, tlrticketmagnet <[EMAIL PROTECTED]> wrote:
>
> is there a simple way to perform either the left or right function
> which instead of specifying positions, you specify a character? for
> instance Seattle, WA I want to pull all of Seattle but nothing right of
> the e (dont want the ,)
>
> the data I have is all mixed and matched with various cities and
> countries so its not consistent except for the ,.
>
> Thanks.
>
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
--
Eddie
[Non-text portions of this message have been removed]
SPONSORED LINKS
Microsoft access database Database development software Database
management software Database software Inventory database software
Membership database software
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "ms_access" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
---------------------------------
Jiyo cricket on Yahoo! India cricket
Yahoo! Messenger Mobile Stay in touch with your buddies all the time.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
