Re: Split one field into two fields

Dont be too quick to implement this.

What will happen when you get something like:
White Sands, New Mexico 12345-6789.  Not all the addresses will be so nice

and neet, and some people may have multiple address lines for the street 
address.  Whatever users can enter they will.

I am just suggesting that there may be inconsistent data.  Depends how the

data field was made.  This may work for the majority of the data but make 
gabage of some of the data.

<PRESENT321@[EMAIL PROTECTED]
> wrote in message 
news:1160313086.331842.72650@[EMAIL PROTECTED]
> Hi!  I have a field in a MSSQL2000 database that is actually three
> fields.
> Sample data:
> billing3
> Toccoa, GA 30577
>
> I would like to run a query like this:
> select [something] as city, [something] as state, [something] as zip
>
> Can you fill in the [something]'s for me?
>
> Thanks,
>
> Matthew
>