Thanks for all the advice

This looks like it will handle the ssn at the beginning and end
and if I wanted to "X" out numbers with 11 characters...

I wanted to remove only ssn , numbers formatted as 999999999 or 999-99-999

I did notice the erics function worked on some but not other

Thanks so much..
got to do a little googling on PATINDEX, it will drive me crazy if I dont understand how its all working!!

Thanks again and...

Hi Eric

Post was empty

Thanks Eric..

Sorry I suck at this so bad!! lol

/****** Object: UserDefinedFunction [dbo].[RemoveNumericCharacters]  Script Date: 7/7/2017 2:44:41 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER...

Hi Eric

Thanks that's exactly what I need to do
Now I can't figure out how to add to my sp

here is a  snippet

Hi

This seems to work...

data.value('sum(/Data/Income_x0020_Source_x0020_Amount/ST2/Monthly_x0020_Income_x0020_Amount)', 'float') as OtherIncome

Thanks

Hi

So with a little thought, I decided to try to get data a level up using

, Data.value('(./Data/Monthly_x0020_Income/Monthly_x0020_Income_x0020_ST)[1]','varchar(50)') As [Earned_Income]

My output shows EarnedIncome301, GA, abc101, etc....

wondering if I...

Hi Drew,

Gave it a try getting "The XML data type cannot be compared or sorted, except when using the IS NULL operator."

Read something about having to convert the XML field?

Tried...

Hi Drew,

Thanks so much for the info..

I need to go over it for me to get a better understanding (Having a hard time grasping XML fields...lol)

So I may...

Great Idea, never even thought of that will get back with results...

Thank you!!

Thanks for the quick response and sorry for the lack of explanation on my part!!

I am using a Bulk insert via a txt file and was...

Thanks !!!!

Shouldn't I have "If_x0020_Other" somewhere in the cross apply?

Thanks Gail...

Any it's always a good thing when you learn something new !!!!

Thanks Again