Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    5

    Unanswered: NULLs in isql output

    Hello !

    How do I take away the default "NULL" in isql-output for NULL-values

    ..it looks like this:
    |REC |NULL|NULL|0632

    and I want it to look like:

    |REC | | |0632

    regards/
    HeBa

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524

    Re: NULLs in isql output

    use
    Code:
    select ... coalesce(YourColumn, "") ...
    from ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •