Using the request : 
 
SELECT DISTINCT journal
FROM reference
WHERE TYPE = 'article' AND etat = 'published' AND journal = 'Physical Review
Letters'
 
I get two type of answers 
One with 'Physical Review Letters' 
(WHERE `journal` = 'Physical Review Letters' )
 

the other with 'Physical Review Letters ' 
with an additional blank at the end of the journal name. 
(WHERE `journal` = 'Physical Review Letters\r\n'     ) 
 
How to select with the exact journal name only.
Thanks for your help,
 
L. Barbier 
 

 
 
_____________________________________________________________ 
Luc BARBIER 
DSM/DRECAM/SPCSI 
Bāt 462 
CEA Saclay 91191 Gif-sur-Yvette Cedex 
E-Mail : [mailto:[EMAIL PROTECTED] 
Tel : 33 (0)1 69 08 51 60 
FAX : 33 (0)1 69 08 84 46

 

Reply via email to