tiffn

In my query I want the result to return all persons who's first names start with the letter 'O':

any help

BigDaddy71

Most databases would let you do the following:

SELECT * FROM persons WHERE first_name LIKE '0%';

The % symbol means anything, so it would match O, Oh, O'Reilly, Ortiz, etc.

Hope that helps.

noctechie

hey BigDaddy71,
Your tip was a great help for me.

Noctechie
EverQuest Geek