Hi,
I've done this:
create table 'brona''-klucka' ('brona''-kluc"ka' int)
insert into 'brona''-klucka' ('brona''-kluc"ka') values (1);if I try: select * from 'brona''-klucka'; then it realy returns >1<, but how can I address the field? select "brona''-kluc"ka" from 'brona''-klucka'; //of course wrong select "brona''-kluc\"ka" from 'brona''-klucka'; //not so obvious but wrong too select 'brona''-kluc"ka' from 'brona''-klucka'; // returns >brona'-kluc"ka< it's treating the column as a string... I figured out that there have to be double quotes (select "name","surname" from person) to treat the indentificators as column names, not the strings (that happens if you use quote (select 'name','surname' from person)). But what to do if there are some double quotes in field name???? Or is there some exact description of single-double quote behaviour??? Brona --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
