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
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
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 Drives
Memory
Video Cards
Monitors
i want to select all the rows that begin with the letter M (Motherboard,
Memory, Monitors)
any suggestions?
