decimal parameter in custom sql when connecting to oracle from power query

[yasmeenwilde]

Hello community members,

I'm looking for the correct syntax for decimal parameter. The below m script below works if rate is a text parameter. It produces an error if rate is a decimal parameter. The condition needs to be stringcol >= pID

This is a directquery connection. I have a huge table with million rows of data. I am trying to get a small subset of data into power query. I've googled and searched through the community. I found answers for text and datetime parameters but unable to find decimal parameter. Please help. 

let
pID=rate,
Source =
Oracle.Database("databasename",
[HierarchicalNavigation=true,
Query="SELECT * FROM schema.tablename#(lf) where stringcol='"&pID&"'"])
in
Source

[lbendlin · Accepted solution]

let
Source =
Oracle.Database("databasename",
[HierarchicalNavigation=true,
Query="SELECT * FROM schema.tablename#(lf) where stringcol='" & Text.From(rate) & "'"])
in
Source

[yasmeenwilde]

Thank you so much @lbendlin this works when I changed the = to >=.

On my original script above, I received a syntax error when I changed = to >=.