New to databricks SQL - where clause issue

[Cblunck]

Hello community,

Using Databricks SQL for the first time and I was hoping I could just copy and past my queries from SSMS across and update the table names, but it's not working.

Found it's the where statement, which I updated the ' ' to " " but still no luck. Below is a snip of the column with some values in it and my WHERE statement. Returns 0 rows though...

What is going wrong here?

where t517f215_paye_tax_category = "GROSS"

 

[Debayan]

Hi, Could you please recheck the format, sometimes copying mismatches the format, also, please refer: https://docs.databricks.com/sql/language-manual/sql-ref-syntax-qry-select-where.html . It has to be ' '.

[Cblunck]

Hi @Debayan Mukherjee​ 

Thanks, unfortunately though I re-wrote the query from scratch and it's still not returning a result.

[justinghavami]

Hi, were you able to get this figured out? I am having the same issue.