Concatenate String in Firebird

Navigation
0

How to concatenate String in Firebird?

I'm trying like this: 

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

I have tried with parentheses, no parentheses, with column name, without the column name ... it just will not ...

is giving the following error:

  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.

    
asked by anonymous 12.08.2015 / 22:29

2 answers

3

I've changed the double quotation marks "" with single quotation marks "and it worked, I do not know if it's the program that I use IB expert or if it's Firebird,     

13.08.2015 / 15:33
3

Exactly the interpretation pattern of a string in IB is using single quotation marks even if you are correct in the conclusion.

Att.

    
25.08.2015 / 03:58
Add variables with Javascript Chrome locks with correct JavaScript loop