Joined: 12 Jan 2011
Location: United States
Online Status: Offline
Posts: 5
Topic: How to suppress a comma but in command it has this Posted: 12 Jan 2011 at 5:30am
In Edit Command this is part of a big SQL...
to_string_sorted(CAST (COLLECT (RESP_PERSON) AS varchar2_ntt),', ') AS RESP_PERSON
Usually there is data to put a person but there are ocassion there is no valid person etc.. but it will this put a comma in there.. it is a very minor issue.. how do I supress this comma in the person.command Field? Thanks
Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Posted: 13 Jan 2011 at 4:55am
Hi
so the person filed could be NULL check ISNULL and insert comma if person field is NULL you may need to expt a bit as which part the ISNULL function will fit in.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
