Re: how to solve it?

On Mon, 07 Jul 1997 15:44:27 -0700, Jean Xu <xu_at_platinum.com> wrote:

>I try to select some records from a table as following:
>
>SELECT * from file
>where filename='file.sql';
>
>It did not return any rows(there is one record satisfied this
>condition). I think the reason is the dot(.) in the filename. Can
>anybody tell me how to make it work?

There might be spaces in front of or after the text. Try

SELECT * FROM file_tab
WHERE filename LIKE '%file.sql%';

Andreas

Andreas Dunker                    2B || ! 2B
adunker_at_picture-safe.de        (W. Shakespeare)