Gilles wrote:
Hello
I'm no SQL guru, and need to look up phone numbers in a SQLite database
that start with certain digits. Some customers use
http://en.wikipedia.org/wiki/Direct_Inward_Dialing, which means that the
first part is common to all the numbers assigned to this customer, so I
don't need to enter every single one of them, and just assign the
prefix, eg. "123" matches "1230001", "1230002", etc.
Should I use the LIKE command for this? Does someone have an example to
do this?
SELECT * FROM Table WHERE Field LIKE '123%';
Use % as your wildcard, and you're good to go.
--
Scott Baker - Canby Telcom
RHCE - System Administrator - 503.266.8253
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
