seperating an address field....?

Does anyone know an easy way to seperate an address in one database field into a couple of different fields.

if i have the following in one table

address:
1234 Main St.

number road_name Type
1234 Main St.

is this possible?It is very much possible. Just make fields for different sections of the address.

id
addr_streetNumber
addr_roadName
addr_type

I usually store the whole street as one then store the city/state/zipinformation in different fields. What db are you trying to dothis for?
it is sql server.

the issue i'm trying to figure out is that the addresses are not in thedatabase in a consistent manner. Here is a random sample of whatmy be in there. I thought about using the split() method, butknow I don't think this is the way to go.

Thanks for the help

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
6011 CENTURY OAKS DR

3224 S HI LO CIR

P O BOX 11400

4105 9TH AVE.

1109 JORDAN LANE
I've spent a lot of years in the mailing industry and I knowall-too-well how inconsistent user-entered data can be. The firststep is to make the data consistent. My suggestion to you is topurchase an address standardizationprogram. This will go up against a USPS database and correct yourdata, and as an added bonus plus it can field your data automaticallythe way you need.
"My suggestion to you is topurchase an address standardizationprogram"
Any suggestions on a good product? Does it allow batchprocessing? We have about 20,000+ records that need to bevalidated and seperated.

Thanks.
Is this an ongoing need or one time only?

Personally I've used BCC Software'sMail Manager product for bulk address processing. And I've usedMelissa Data's APIs for individual address standardization from within an application.

If this is a once-and-done process, Melissa Data is one of many companies offeringCASS certification as a service, and they price their service per thousand records.
one time thing. thanks for the help... i'll look into those options.