That worked Thanks All,

Now one more missing peice...

I copy good data into a new table then I run the parsing query which seperates my data the way I want...

Server: Msg 8114, Level 16, State 5, Line 1

Error converting data type varchar to float.

New Error after uncommented

INSERT INTO dbo.raw_data_pro

Select *

FROM raw_data[raw_payload]

Where raw_payload like '%+%+%'

This works but the parsing does not....

SELECT raw_payload,

LEFT(raw_payload+'+++', CHARINDEX('+', raw_payload+'+++', 1)-1),

...

WHEN I RUN THIS:

INSERT INTO dbo.raw_data_pro

VALUES ('raw_seq_no','raw_date','raw_dev_id','raw_rec_type','raw_payload','raw_processed')

Select *

FROM raw_data[raw_payload]

Where raw_payload like '%+%+%'

I GET THIS ERROR...

Server: Msg 8152, Level 16, State 9, Line 1

String or binary data would...

Select *

FROM raw_data[raw_payload]

Where raw_payload not like '%+%+%'

This finds all the bad data is there some thing I can add to auto delete based on this query like a stored...

I dont know enough about SQL to any of this I just know what I want, the bad data or non standard data can be trashed with no problems.

What if we could write a query that says pickup all data that meets this standard

text(*) '+' NUM(*) '+' NUM(*) copy to new table then parse into a new...

Yes that is the problem I do have some bad data, 1 or 2 lines per every 600 is stepped on data its un unavoidable buffering issue with the device...

SELECT raw_payload,

LEFT(raw_payload+'+++', CHARINDEX('+', raw_payload+'+++', 1)-1),

CAST(--NULLIF(

...

CODE PASSED:

DECLARE @table TABLE (raw_payload VARCHAR(200))

INSERT INTO @Table SELECT raw_payload FROM raw_data

SELECT LEFT(raw_payload, CHARINDEX('+', raw_payload, 1)-1),

...

No your clear and I am the missing something in the statement where would you add the null and or no delimiter statement....

YES, some null and some stepped on data, its rs232 data coming over ethernet out of 30000 rows there maybe 20 bad and i am trying to purge them any...

Tried this

DECLARE @table TABLE (raw_payload VARCHAR(200))

INSERT INTO @Table SELECT raw_payload FROM raw_data

SELECT LEFT(raw_payload, CHARINDEX('+', raw_payload, 1)-1),

...

Ok, I got it to display the way you said, but I think the issue is me not explaining properly,

I have a database with a table called raw_data and...

Call me SQL stupid because I am, but its the small adjustments that are confusing me...Sorry

I ran your query and it came back with one row effected. but displayed...