Extracting in SQL Server 2005

20 pts.
Tags:
EXTRACT
Field-Level keywords
SQL 2005
SQL 2005 Database
SQL Server 2005
IS THERE ANY WAY TO EXTRACT FROM A FIED

EXAMPLE: I HAVE A ADDRESS LINE AS 1065 VALLEY LANE APT 120

                                                      SCHAUMBURG

                                                       IL 60195

I NEED TO EXTRACT APT 120  INTO ANOTHER LINE LIKE APT 120

                                                                     1065 VALLEY LANE

                                                                      SCHAUMBURG

                                                                       IL 60195



Software/Hardware used:
SQL 2005

Answer Wiki

Thanks. We'll let you know when a new response is added.

Your best bet would be to use a regular expression through a SQL CLR procedure.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    Please provide more details. What exactly do you mean by "into another line" ? Are you currently storing all the address information in a single table field ? In your specific example you want to extract "APT 120", but, what would you want to extract from other records ? is there a pattern ?
    70,220 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following