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"