You’re offline. This is a read only version of the page.
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 (
SELECT sum([Sales])
WHERE CONTAINS(shop, '7-11');
Or possibly:
SELECT sum([Sales])
WHERE shop like '%7-11%';
#1
WarrenBelz
146,587
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,928
Most Valuable Professional
