The sqlserver database belongs to another app - not ours. We are simply providing an interface to the data for viewing purposes.

>Hi Tracy,
>
>Just a thought... something I learned from Tom Rettig (but have not been diligent in applying to my own work). Why not leave the address (at leasy the "street address" part) in a memo field where you are free to format it anyway necessary including adresses worldwide? Then, for filtering and index purposes, add additional fields shuch as state/province, postal code etc.
>
>Your environment may prevent you from doing this and I realize the potential for mismatched memo info versus field info but...
>
>As I said, just a thought.
>
>Ken
>
>
>
>>This must've been done a thousand times already. I have parsed addresses before but I cannot seem to wrap my head around this today. (Friday)
>>
>>Some examples of user typed values:
>>

>>100 N Main St
>>3001 No W Rubick Ave     && number=3001, st_prefix = No, Street=W Rubick, st_type = Ave
>>12 Sycamore Dairy Rd NW  && number = 12, street=Sycamore Dairy, st_type=Rd, st_suffix = NW
>>1312 S Cain St E Suite A10 && number = 1313, st_prefix=S, street=Cain, st_type=St, st_suffix=E, apt_room=Suite A10
>>100 N Main St NW Ste 110
>>210 Jones Dr Apt 1E
>>8700 Smith Rd
>>

>>Parse the values typed above into these fields:
>>

>>number c(10)        && 100, 3001, 12, 1312, 100, 210, ...
>>st_prefix c(10)     && NW, S, E, NE...
>>street c(30)        && Main, Cain, ...
>>st_type c(10)       && Blvd, ST, AV, ...
>>st_suffix c(10)     && NW, S, E, NE, ...
>>apt_room c(10)      && Apt 102, Suite 109, etc...
>>

>>
>>Anyone up to the task on a Friday?
>>
>>TIA,
>>Tracy