Re: [SQL] TR: Like and =

2003-06-26 Thread Nicolas JOUANIN
la part de Dani Oderbolz > Envoye : mercredi 25 juin 2003 14:19 > A : [EMAIL PROTECTED] > Objet : Re: [SQL] TR: Like and = > > > Nicolas JOUANIN wrote: > > >Hi, > > > > Thanks for your help. In fact that means 2 solutions for this: > > > >1) select

Re: [SQL] TR: Like and =

2003-06-23 Thread Nicolas JOUANIN
s [mailto:[EMAIL PROTECTED] > Envoye : lundi 23 juin 2003 18:54 > A : Nicolas JOUANIN > Cc : [EMAIL PROTECTED] > Objet : Re: [SQL] TR: Like and = > > > > Hi Nicholas, > > CHAR fields, as opposed to VARCHAR, are blank-padded to the set length. > > There

[SQL] TR: Like and =

2003-06-23 Thread Nicolas JOUANIN
desc char(50), CONSTRAINT pk_pdi PRIMARY KEY (pro_id,pmf_id,lng_id) ); Nicolas. --- Nicolas JOUANIN - SA REGIE FRANCE Village Informatique BP 3002 17030 La Rochelle CEDEX Tel: 0

Re: [SQL] CREATE table1 FROM table2

2003-06-17 Thread Nicolas JOUANIN
Hi, Documentation says: CREATE [ [ LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name [ (column_name [, ...] ) ] AS query example : create table table1 as select * from table2; > -Message d'origine- > De : [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] la part de Rado Petrik > Envoyé

[SQL] Let join syntax

2003-06-16 Thread Nicolas JOUANIN
fred Koizar [mailto:[EMAIL PROTECTED] > Envoye : lundi 16 juin 2003 16:40 > A : Nicolas JOUANIN > Cc : [EMAIL PROTECTED] > Objet : Re: [SQL] Let join syntax > > > On Mon, 16 Jun 2003 12:34:34 +0200, "Nicolas JOUANIN" > <[EMAIL PROTECTED]> wrote: > >fro

[SQL] Let join syntax

2003-06-16 Thread Nicolas JOUANIN
rite this query correctly ? Regards, Nicolas. ------- Nicolas JOUANIN - SA REGIE FRANCE Village Informatique BP 3002 17030 La Rochelle CEDEX Tel: 05 46 44 75 76 Fax: 05 46 45 34 17 email: [EMAIL PROTECTED] Web : www.r