Thanks A Lot

Excellent!

Worked great Thanks

Thank you I appreciate your advice. I've looked up a VBS function and will try and use this with SSIS .

Dim strAryWrd

Dim strValue

Dim strValue1

strValue = "EBRND, DIET ...

Thanks ALL

Here is the solution I came up with.

DECLARE @x VARCHAR(80)

SET @x = '400.367.369.379'

SELECT

SUBSTRING(@x++'..',CHARINDEX('.',@x++'..')+1,CHARINDEX('.',SUBSTRING(@x++'..',CHARINDEX('.',@x++'..')+1,DATALENGTH(@x++'..')))-1)

Thanks for all your help

399. = NULL

400. = NULL

400.367. = 367

400.35.369. = 35

37.367.369.3 =367

400.367.369.379. = 367

Thank you

I do realize that Thank You.

This works. Thanks