Hi, Try :
SELECT * FROM yourtable WHERE word LIKE 'D%'; Regards, Jocelyn ----- Original Message ----- From: "Chuck "PUP" Payne" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, September 08, 2002 2:42 AM Subject: Have A problem > Hi, > > I got a small problem I can't seem to do a sql statement that will pick on > the first letter of word in a feild. I have over 700 record in a database, > but I like to be able only to see those that let say start with "D". How can > I do a statement that will let me do that. > > Chuck Payne > Magi Design and Support. > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php