Extracting in 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
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
ASKED:
October 27, 2010 1:17 PM
UPDATED:
October 27, 2010 9:31 PM
Answer Wiki:
Your best bet would be to use a regular expression through a SQL CLR procedure.
To see all answers submitted to the Answer Wiki: View Answer History.
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 ?