Change blank entries from database

[Anonymous]

Hi,

this is a part of my script:

MitgliedArb:

SQL SELECT AbmeldeDatum

FROM "CRM".dbo.MitgliedArb;

The field "AbmeldeDatum" is in the database partially empty.

These blank entries should be changed into a date like "01.01.2500".

Can someone help me ?

[sunil2288]

HI Dirk

You can write

if(value(Abmeldedatum=' ',value(Abmeldedatum)='01-01-2500',value(Abmeldedatum)) as Abmeldedatum

Regards

Sunil

[#3]

In the script main page

SET NULLDISPLAY=<01.01.2500>;

[jonathandienst]

Hi

On SQL Server:

SQL SELECT COALESCE(AbmeldeDatum,CONVERT(datetime, '01.01.2500', 104)) AS AbmeldeDatum

FROM "CRM".dbo.MitgliedArb;

Jonathan

[#5]

Hi

Please write this script.

if(trim(len(AbmeldeDatum))=0,'null',AbmeldeDatum) as AbmeldeDatum

Regards

Ashish

[Anonymous]

Thank you all.

I use the solution from Ashish Srivastava.

The other proposals also work´s.