Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Postbox — — source: Informix-list mailing list archive (1991-1998)
Does anyone no how to select one row from a table based on the first or
part of an or expression ?
Example:
select price from oplist where product_code = ? and price_list = ? and
(customer_code = ? or customer_code is null')
I need to select one row if customer_code is not null or one row if
customer_code is null. Not two rows as is happening due to one row with a
customer_code and another with a null value.
Does anyone have any suggestions?
Regards,
Peter Neville.
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.