View Full Version : help with like query

01-17-2008, 06:08 AM
hi, i want to select all the words from a table which begin and end witht he same alphabet
eg: i want all words starting with s and ending with a.
like samantha,sara,shilpa, etc.
can someone pls help me with the query.
thnks in advance..

01-17-2008, 07:08 AM
Try this one

SELECT words FROM wordstable WHERE words LIKE 's%a';

Note that the table and field name is just for an example.