Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by David Poole An Is Null Gotcha RE: An Is Null Gotcha

  • July 14, 2005 at 2:10 pm

    #574576

    On the other if you were to use COALESCE you code could look like this

    SELECT @PatientHospitalID = COALSESCE (LTRIM(RTRIM(@PatientHospitalID)), 0)

    shorter and eaiser to read imho