I tried this lynn to no avail. I dont understand

delete...

Thank you for clarifying for me

Thanks all for the help I feel kinda stupid now. Yes it should not have been shipped date it should have been

delete LMOrders where OrderDate between 10-10-1996 and...

I get this error when i try it that way

Msg 241, Level 16, State 1, Line 1

Conversion failed when converting date and/or time from character string.

thank you so much you saved my life lol

thanks, its almost what i was looking for but i need all input to be accross one row ill like the first example

and not like second