postgreSQL query help?

[Keiko]

Hia, I need to create a query that will return a list of names, where each name starts with a given letter and ends with another given letter.

Can anyone help?

Thanks.

[shadow3dcaster]

SELECT names FROM table_name WHERE names='J%S'

this would find names like James or Jones.