Hi



You have put 2 more ' as was necessary !

Try this:

select '"'||MON$USER||'","'||MON$ROLE||'"' from MON$ATTACHMENTS



Regards,

Paul



From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of legrand_legrand_63
Sent: Friday, July 06, 2007 12:41 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] select '"'||field||'"' is wrong



Hello,

when trying the folowing statement in FB 2.1:
select '"'||MON$USER||'"','"'||MON$ROLE||'"' from MON$ATTACHMENTS;
the result isn't the one expexted, but is:
"SYSDBA,"DBA

is that normal ?
Regards
PAscal





[Non-text portions of this message have been removed]