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]
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/
