SQL Where LIKE - Range it! - Mailing list pgsql-general

From steagus@S1PA3M2FIL4TE9Ryahoo.com (Steagus)
Subject SQL Where LIKE - Range it!
Date
Msg-id 3ae881af.275381347@news
Whole thread Raw
Responses Re: SQL Where LIKE - Range it!
Re: SQL Where LIKE - Range it!
List pgsql-general
H-

I've found the docs on how to select a list of rows from a table were
all the records have a last name starting with 'W%'.
select * from table where last_name LIKE 'W%'

What I'd like to do is pull a list of records where there is a range
of last names; say from A - F.
select * from table where last_name LIKE 'A%' AND last_name LIKE 'F%'
- for example.

The above code I've tried for this doesn't seem to work as I'd expect
it too?
I've even done
select * from table where last_name LIKE 'A%' AND LIKE 'F%'

Can anyone provide some details or insights on how to accomplish this?


Thanks. Much appreciated.
-Steagus


pgsql-general by date:

Previous
From: "Mike Goetz"
Date:
Subject: running pgaccess on localhost
Next
From: Calvin Dodge
Date:
Subject: Re: SQL Where LIKE - Range it!