SQL Wildcard searches

[tiffn]

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

any help

[BigDaddy71]

Originally Posted by tiffn

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

any help

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