Hi Jeff,

Sorry for the late response. I was off for the thanks giving weekend. You didnt post your solution here.

This is the table and sample data (Attached below)

my out put shoud be something like this.

My function does the splitting of the address field .

Thank you in advance

This is my function

CREATE FUNCTION [dbo].[ParseAddress]

(

@Address VARCHAR(8000) ,

@Delimiter...

I dont want to join the function and the table ...i want to pass data in the column from the table as a variable to the function

Thanks a lot guyz that was helpful

sample data

----------------------------------------------------

String

----------------------------------------------------

122 campbell ave., west haven, Arizona 00000-0000

248 mac arthur blvd., irving, New York 11111-1111

123 xyzs, abcd, New Jersy 22222-2222

----------------------------------------------------

There is one more added complexity , in some recordds the state has for example

Arizona

New Jersy

instead of just their abbreviation

Thank you soo much....

Hi,

Thank you for your reply

The source data is consistent. the only problem is there is no ',' in the string between the state field and the zip and the zip...

Thank you Brandie...

No we dont have an admin

While performing check in i'm getting a warning "Internal error in changeset comments policy

Thank You Wayne...that helped me...

so u dont want to insert that record from client B rite?

Hi,

This might help you.

USE AdventureWorks;

GO

SELECT name, create_date, modify_date

FROM sys.objects

WHERE type = 'P'

AND name = '<user defined stored procedure>'

GO