Skip to content
Advertisement

Tag: ifnull

using sql – Is not null in a select statement

I can’t seem to figure out how to use the opposite of isnull or ifnull statements in sql. I need to say if a.Error1 is not null — then print the ‘ – ‘ and the + CHAR(13)+CHAR(10). Basically There should be no dash or no new line break if the a.Error1 comes back null. So print the information if

Advertisement