Can't seem to get the syntax right ....ugh! This is being used to build an XML file in case one wonders.
CASE A0600A WHEN '000000000' THEN '^' ELSE CASE A0600A IS NULL THEN '^' ELSE CASE A0600A WHEN '' THEN '^' ELSE A0600A END END END
If A0600A is "000000000", is null, or is blank then I want a '^' otherwise what ever the value of A0600A.
A0600A is a VARCHAR data type by the way.