celticpiping (10/26/2015)
hmmwell, 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 makes sense..it IS a char type after all...
thanks fellers..
NP. Thank you for figuring out what you did because it means that it's not an MS bug that you came across.
--Jeff Moden
Change is inevitable... Change for the better is not.