Isnull get the next SQL condition

0

How can I do it on SQL server a condition if the return of a field is null and it returns another condition

ISNULL( CONVERT(CHAR(08),C.PEDS_DAT_FAT,112), d.NFFE_DAT_ENT) BETWEEN '20180501' AND '20180530')

I'm not sure what to do, but I'm not sure what to do.     

asked by anonymous 07.06.2018 / 22:59

1 answer

0

So I understand you should check if the field is null before conversion; then it would look like this:

CONVERT(CHAR(08), ISNULL(C.PEDS_DAT_FAT, d.NFFE_DAT_ENT), 112)
BETWEEN '20180501' AND '20180530'
    
08.06.2018 / 14:14