Viewing 2 posts - 1 through 2 (of 2 total)
Hmm...Product Code 1003 has the below possible descriptions, so 1003 will not be retrieved. 🙂
"Item 3 X Large"
"Item 3 XX Large"
February 3, 2012 at 4:45 pm
#1442694
Or maybe this? 😎
select [Product Code], Description, Cost from Table1
where Description = 'Item 1 X Large' or (Description='Item 1 XX Large' and Cost=25)
February 3, 2012 at 3:35 pm
#1442681