understood: I should have known to post table data.

I'll attempt to provide table data below.

Source table, and associated insert code:

DROP TABLE #shipping_data;

CREATE TABLE #shipping_data(

tracking_no NVARCHAR(MAX) NOT NULL...

Howdy again Lynn, things crashed around here so been ..bisy

Say, not sure if I've used up my newb-requests for this month, but

concerning the query we've put together, I was wanting...

yeah, I must have left off the tracking # on row3..oopsies

ok, I shall parse the supplied code...

Thanks!!!

R

ok, fair questions

I did have a THEN: totally left it off for no reason..

The end goal is to find those "order_no's that are over 7 characters in length,

and if so,...

hmm

well, I must have highlighted the top line...

because I re-ran, and deleted 1 row with:

delete shipping_data

where order_no='1000002'

and running;

delete shipping_data

where order_no=1000002

produced an error: "Conversion failed when converting the varchar value"

which...

wow, very interesting..!

I'll surely let you know what I find

R

huh, very interesting..

well, I suppose then, if SQL rules dictate that it could NOT

have deleted everything, then I MUST have selected the top line.

But I think when I'm back in...

well, things got more complicated, by the fact that a given order_no, can have multiple tracking_no values attached to it....

ugh

I soldier on....

ok, many thanks: lemme see what trouble I can get into with that direction...

Rich

SSC,

you pretty much described what I'm trying to do..

Sadly, I have to fess up, I don't understand how the code you present

correlates to the "real" SQL tables...

I've never used...

Wow, I HATE when I lose an entire post...

Here goes again

So, I'm attempting to do the INSERT statement thing below to help with this issue.

Again, my goal is to match...