Concatenate String in Firebird

Asked

Viewed 12,708 times

0

How to concatenate String in Firebird?

I’m trying like this:

select ("00"||"01") AS TESTE  from tabela

I’ve tried parentheses, no parentheses, column name, no column name... it just won’t...

is giving the following error:

can’t format message 13:794 -- message file c: Program Files Borland Interbase/Interbase.msg not found. Dynamic SQL Error. SQL error code = -206. Column Unknown. 00. Unknown ISC error 336397208.

firebird syntax

  • It’s like, too bad there’s no way I can test.

2 answers

4

exactly the interpretation pattern of a string in IB is using simple quotes even you are correct in the conclusion.

Att.

3


I switched the double quotes "" by single quotes '' and it worked, I don’t know if it’s the program I use IB expert or if it’s Firebird, all I know is that it’s solved.

Browser other questions tagged firebird syntax

You are not signed in. Login or sign up in order to post.