"Hermann Muster" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Hi,
I encountered something I can't really explain. I use the following
statement in my application:
COALESCE(UPPER(SUBSTR("Y"."Firma",1,7)),'')
This returns "ERROR: syntax error at end of input"
However, using
On 13 fev, 12:19, Hermann Muster <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I encountered something I can't really explain. I use the following
> statement in my application:
>
> COALESCE(UPPER(SUBSTR("Y"."Firma",1,7)),'')
>
> This returns "ERROR: syntax error at end of input"
>
> However, using the fol
Michael Fuhr schrieb:
On Thu, Feb 14, 2008 at 04:48:33PM +0100, Hermann Muster wrote:
Michael Fuhr schrieb:
COALESCE(UPPER(SUBSTR("X"."Firma",1,7)) =
I haven't examined the entire query but the above line appears to
be the problem. Did you mean to write the following?
On Thu, Feb 14, 2008 at 04:48:33PM +0100, Hermann Muster wrote:
> Michael Fuhr schrieb:
>>> COALESCE(UPPER(SUBSTR("X"."Firma",1,7)) =
>>
>> I haven't examined the entire query but the above line appears to
>> be the problem. Did you mean to write the following?
>>
>> COALESCE(UPPER(SUBSTR
Michael Fuhr schrieb:
[Please copy the mailing list on replies so others can contribute
to and learn from the discussion.]
On Thu, Feb 14, 2008 at 09:56:36AM +0100, Hermann Muster wrote:
The statement I'm using is the following:
SELECT
"FIRMEN"."Firma","FIRMEN"."Firma2","FIRMEN"."Firma3","F
[Please copy the mailing list on replies so others can contribute
to and learn from the discussion.]
On Thu, Feb 14, 2008 at 09:56:36AM +0100, Hermann Muster wrote:
> The statement I'm using is the following:
> SELECT
> "FIRMEN"."Firma","FIRMEN"."Firma2","FIRMEN"."Firma3","FIRMEN"."Such","FIRMEN"
On Wed, Feb 13, 2008 at 04:19:09PM +0100, Hermann Muster wrote:
> I encountered something I can't really explain. I use the following
> statement in my application:
>
> COALESCE(UPPER(SUBSTR("Y"."Firma",1,7)),'')
>
> This returns "ERROR: syntax error at end of input"
Please show a complete sta
Hi,
I encountered something I can't really explain. I use the following
statement in my application:
COALESCE(UPPER(SUBSTR("Y"."Firma",1,7)),'')
This returns "ERROR: syntax error at end of input"
However, using the following statement is fine:
COALESCE(SUBSTR(UPPER("X"."Firma"), 1, 7), ''