PDA

View Full Version : postgreSQL query help?


Keiko
10-11-2007, 11:26 PM
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
10-11-2007, 11:26 PM
SELECT names FROM table_name WHERE names='J%S'

this would find names like James or Jones.