Re: [GENERAL] line CASE statemelnt in query a la Oracle

2010-09-08 Thread John R Pierce
On 09/08/10 10:05 PM, Dennis Gearon wrote: I would like to have a query replace a NULL in a field with a truncated value from one field based on a size passed in? Basically, I'd like to be able to generate a 'short title' for a record based on either the user's input for a short title, or a

[GENERAL] line CASE statemelnt in query a la Oracle

2010-09-08 Thread Dennis Gearon
I would like to have a query replace a NULL in a field with a truncated value from one field based on a size passed in? Basically, I'd like to be able to generate a 'short title' for a record based on either the user's input for a short title, or a turncated 'normal title' at query time. Wo