Hi Chuck, or take a look at the LEFT() function. =dn
> 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 > > --------------------------------------------------------------------- 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