Re[2]: Packing Commas in a Quiz - but not too many

[Rohde Dirk (Van)]

Note, if using an Oracle database, " " is not equal to "".  If checking
items that have a blank in them, you must check for " ".

> -----Original Message-----
> From:	Chris.Sharman@ccagroup.co.uk [SMTP:Chris.Sharman@ccagroup.co.uk]
> Sent:	Friday, May 08, 1998 6:51 AM
> To:	Leonard_Berkowitz@harvardpilgrim.org
> Cc:	powerh-l@lists.swau.edu; Chris.Sharman@ccagroup.co.uk
> Subject:	RE: Re[2]: Packing Commas in a Quiz - but not too many
> 
> >Tony's answer is a good one. I'd add:
> >
> >ELSE "" <that's a null string> or perhaps
> >ELSE " " and count on PACK to squeeze out the extra space(s).
> 
> The trailing ELSE's are redundant and inefficient (so I believe & so
> the Cognos
> folks have said in the past).
> 
> You can rely on character items being spaces if they aren't
> initialised to
> anything else, and similarly date/numeric items being zero.
> 
> Also "" = " " = "  " etc: character strings are truncated / space
> padded as
> necessary to fit.
> ______________________________________________________________________
> Chris Sharman			Chris.Sharman@CCAgroup.co.uk
> CCA Stationery Ltd, Eastway, Fulwood, Preston, Lancashire, PR2 9WS.
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> = = =
> Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to
> majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a
> subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.