select and spaces in end of field

Giganews Newsgroups
Subject: select and spaces in end of field
Posted by:  Olivier B (olivier.…@turlututu.free.fr)
Date: Wed, 12 Dec 2012

hello,

one table:

[name]
'toto'
'toto    '
'toto          '

i shearch the syntax for select only toto with the good number of
space after

using  WHERE [name]= 'toto'
return:
'toto'
'toto    '
'toto          '

using WHERE [name] LIKE 'toto    '  return
'toto    '
'toto          '

Thanks for any help.

--
pas de turlututu. apres l'@robase

Replies