You’re offline. This is a read only version of the page.
Announcements
Hi guys.
Using PAD i am trying to run SQL query on Excel file but having problem with value that has hyphen in the middle of it.
my sql is
select sum([Sales])
where shop in ("7-11")
it can run but returns 0 as value.
is there any solution to do this?
thank you
Are you supposed to be using in here? What would the values of shop be?
Where you after something like this instead:
Share
Report
All responses (
Answers (
11,063
SELECT sum([Sales])
WHERE CONTAINS(shop, '7-11');
Or possibly:
SELECT sum([Sales])
WHERE shop like '%7-11%';
