Re: select based letter

2005-07-15 Thread Gleb Paharenko
Hello. What about: select topics from topics where topics like 'M%'; Sebastian <[EMAIL PROTECTED]> wrote: > i have a text field column and i want to select the rows based on the > first letter in this column, eg: > > - > | topics | > - > Motherboard > Hard D

Re: select based letter

2005-07-14 Thread Scott Haneda
on 7/14/05 3:54 PM, Sebastian at [EMAIL PROTECTED] wrote: > i have a text field column and i want to select the rows based on the > first letter in this column, eg: SELECT field from table WHERE field LIKE 'M%' -- - Scott Haneda