Excel - SQL Query - Parameters check for null input

[bell282]

I am using excel 365.
I have a drop down box as an input parameter to a query. I need to be able to check is that input parameter is null.

State: <drop down of available states>

Report showing city, zip code and other data

For the drop down box, I am using the following query:
Select null as [State]
UNION
Select distinct State from tbl_states

Then the query to display the report:

What I am using in the sql statement is:
Select columns
from table_State s
where ( s.State = ? or ? is null )

This is not working.

I know in tsql, it would be written:
declare @State varchar(50)
set @State= 'Ohio'
-- set @State = null
select distinct state
from tbl_States s
where ( (@State is null) or (s.State = @State) )

Any suggestions on how to correct my query?

 

[QuietRiot]

I think you're looking for isnull().

 

[bell282]

Thanks! Yes, isnull does work when I run the query in Microsoft sql server management studio but not excel. I think the 'null' value that I am trying to return is being converted is an empty string.

stumped...

 

[bell282]

Other items I have tried:
Select columns
from table
where column = ? or isnull(?, '') = ''

I have both parameters set to the same input parameter

With this approach, I receive an error message 'string date; right truncation'