Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
HI Dirk
You can write
if(value(Abmeldedatum=' ',value(Abmeldedatum)='01-01-2500',value(Abmeldedatum)) as Abmeldedatum
Regards
Sunil
In the script main page
SET NULLDISPLAY=<01.01.2500>;
Hi
On SQL Server:
SQL SELECT COALESCE(AbmeldeDatum,CONVERT(datetime, '01.01.2500', 104)) AS AbmeldeDatum
FROM "CRM".dbo.MitgliedArb;
Jonathan
Hi
Please write this script.
if(trim(len(AbmeldeDatum))=0,'null',AbmeldeDatum) as AbmeldeDatum
Regards
Ashish
Thank you all.
I use the solution from Ashish Srivastava.
The other proposals also work´s.