is it possible to give a default value for a column which is generated as a result of left outer join...
when there is no value for a particular column it shows null is it possible to change give a default value based on its data type?
Yes, you can use the IsNull function e.g.
ISNULL(ColumnName, ReplacementValue)|||
ok let me try and see whether i can get that working
|||thanks for the help it worked
|||No problem
No comments:
Post a Comment