| Subject | Re: [firebird-support] Re: Why "Like" , "=" return diffent number records? |
|---|---|
| Author | Nando Dessena |
| Post date | 2003-10-08T12:45:31Z |
Svein,
SE> SELECT * FROM RDB$DATABASE
SE> WHERE 'AAA ' LIKE 'AAA'
SE> does not yield any result, whereas
SE> SELECT * FROM RDB$DATABASE
SE> WHERE 'AAA ' = 'AAA'
SE> returns one row.
To me all looks as it should.
--
Nando mailto:nandod@...
SE> SELECT * FROM RDB$DATABASE
SE> WHERE 'AAA ' LIKE 'AAA'
SE> does not yield any result, whereas
SE> SELECT * FROM RDB$DATABASE
SE> WHERE 'AAA ' = 'AAA'
SE> returns one row.
To me all looks as it should.
--
Nando mailto:nandod@...