Loading

Correct way of Enclosure

Ramco Ramco

4y894

Hi

Is this correct way to enclose Dates & columns etc

SET @Where = @Where + ' NOT(T1.U_APDE = ''N'' AND T1.U_ARDE = ''N'') and (T1.U_ItemCode is not null) and (T0.U_DATE BETWEEN ''2021-03-01'' and ''2021-03-31'') '

Thanks

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramco Ramco4y ago
Hi

I am using MS Sql

Thanks
0
Nitin Sontakke4y ago
ALWAYS mention which SQL db engine you are using, SQL Server, mySQL, Oracle, etc.

If this is Microsoft SQL Server I have never seen NOT as a function, always as a operation.

In that case the above would be as follows:
SET @Where = @Where + ' T1.U_APDE != ''N'' AND T1.U_ARDE != ''N'' and T1.U_ItemCode is not null and T0.U_DATE BETWEEN ''2021-03-01'' and ''2021-03-31'''
0