The isnull function requires 2 arguments. 3

[jeffsturgeon2002]

I'm hoping its just a matter of syntax wording ... Which I'm still learning ...

Is it possible to add an ISNULL to this code?

CONVERT(varchar,pp.Birthdate,101) AS Birthdate,

Typically, I use:

ISNULL(pp.Birthdate,'') AS Birthdate,

When I tried to get add an ISNULL to the code, it gave me the following remark: "The isnull function requires 2 arguments.

 

[gmmastros]

IsNull(CONVERT(varchar,pp.Birthdate,101), '') AS Birthdate,


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[PWise]

try this in QA

declare @d as datetime
set @d=null
Select CONVERT(varchar,isnull(@d,''),101) AS Birthdate

 

[PWise]

sorry should be

Select isnull(CONVERT(varchar,pp.Birthdate,101),'') AS Birthdate

 

[PWise]

Sorry gmmastros i did not refresh my explorer

have a star

 

[jeffsturgeon2002]

Thanks George ... and to you pwise!!