i am developing sql query
for ticpr007.ltcp field

i want to select ticpr008.ltcp is blank

i tried to define as where ticpr007.ltcp = ' ' , no report appearing, i checked in the table there is blank record is available.

please suggest. what is to be define in where clause (sql query)

field ticpr007.ltcp is of type date, so the correct syntax should be

where ticpr007.ltcp = 0

regards,
Juergen

i am developing sql query
for ticpr007.ltcp field

i want to select ticpr008.ltcp is blank

i tried to define as where ticpr007.ltcp = ' ' , no report appearing, i checked in the table there is blank record is available.

please suggest. what is to be define in where clause (sql query)

Hello,

in LN ticpr001.ltcp is a utc field (last calulation date)

No date set is "0" zero : where ticpr007.ltcp = 0

-----------
Sorry Juergen, you're faster ;-)

Regards