Sorry, please excuse this post. I found the problem. A single space in front of the account number.
Thanks Richard D. Williams [EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query > > If you just reply to this message, and include the entire text of it in the > reply, your reply will go through. However, you should > first review the text of the message to make sure it has something to do > with MySQL. Just typing the word MySQL once will be sufficient, for example. > > You have written the following: > > Hi all, > I am new to the list. > Situation: > A field in a table is set to a length of 10 and varchar. When alpha and > numeric characters are in the field select using the equal sign is no > problem. But, if only numeric characters are in the field the equal > relation does not select any records. > If I use the like relationship the records are selected, but much > slower. > > Question: > Is there a valid problem here? Is there a special way to get these > records selected using the equal operator? > > Again, just to be clear; > SELECT * FROM wip WHERE acct_num = '111' , does not select records. > SELECT * FROM wip WHERE acct_num like '%111%' , does select records. > > acct_num is a 10,varchar field > > Thanks, > Richard D. Williams --------------------------------------------------------------------- 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
