Force a Null return

[PGMR1998]

How do i make the field PrjMgr return null values?

select AgencyId
,ControlNumber
,ISNULL(LLA_AUDITS.PrjMgr,Projects.PrjMgr) as PrjMgr

 

[PHV]

Any chance you could elaborate ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PGMR1998]

i want the return column PrjMgr to contain all nulls.

 

[JarlH]

Do you perhaps mean
[tt]
SELECT AgencyId
,ControlNumber
,CAST(NULL AS integer) AS PrjMgr
FROM sometable[/tt]

Will return nothing but NULLs in the PrjMgr column.