Hi Team , I have an application already in production.For some reaso

jasleenk over 10 years ago

Hi Team ,

I have an application already in production.For some reason I have to add a new column in the database for that application.

The issue is when i try to query that column it only gives me data for the newer instances and didn't fetch records which has blank values for that column.

I tried with "" , null , null() and <> also but doesn't fetch records for older instances.

Please help....

Discussion posts and replies are publicly visible

Parents

0 venkats533 over 10 years ago

update database and replace all null values with a default value like 1/1/2000 for date or -999 for an integer or "EMPTY" for string types. Then use this default value in your query.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 venkats533 over 10 years ago

update database and replace all null values with a default value like 1/1/2000 for date or -999 for an integer or "EMPTY" for string types. Then use this default value in your query.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data