ilibhart80
asked on
SQL to Parse an address in to street number, street name, and street type
I have a string field with the following: "123 Main Street"
I need to parse the field in to 3 different fields by street number, street name, and street type.
How is the best way to achieve this?
I need to parse the field in to 3 different fields by street number, street name, and street type.
How is the best way to achieve this?
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.