Skip to Content
1
Jan 26, 2023 at 12:07 PM

Fixed SQL Query if Paramerter empty

75 Views

Hi,

I'm using the following where condition in a fixed sql query:

and ([NC_DATA].WORK_CENTER_BO LIKE '%[Param.4]%' OR '[Param.4]' IS NULL)

and its working fine when I enter a value for Param.4, but when I don't use Param.4 it's not giving the NULL paramter only data with values. How can I achieve that I get data with values and also data = NULL

Thanks for helping.