web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate SQL in ("number with h...

Power Automate

Unanswered

SQL in ("number with hyphen") cannot extract data

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

grantjenkins 11,063 Moderator on at

Like (0)

Report
Copy link

Link copied!
Are you supposed to be using in here? What would the values of shop be?

Where you after something like this instead:

SELECT sum([Sales]) WHERE CONTAINS(shop, '7-11');

Or possibly:

SELECT sum([Sales]) WHERE shop like '%7-11%';

Was this reply helpful? Yes No

Join the conversation