sql server - How to return NULL or false value as false -
I have a problem that calibrate the column is blank or incorrect, it 0 is returned, otherwise it returns 1 is, here is my column want bit type to see my statement where I below:
FROM [dbo]. [M_AttributeSet] AttributeSet WHERE (@AD_Org_ID IS NULL or ID AttributeSet.AD_Org_ID IN (fnSplitter (@AD_Org_ID))) and (@ Attelston value has NULL or Attributsat.aletstonvelu = Attlastonvlyue) < P> How can I do this? Thank you for your comments in advance
This is false or 0 and 1 when right: 0 < P>
ISNULL (your column, 0)
Comments
Post a Comment