Hi Using the Square brackets with the characters within it and then a wildcard after the closing square bracket works except for looking for special square brackets.
>hi all, > > >i have this table filled with names. >Does anybody know how I can write a select statement which selects all names >starting with a certain letter in the alphabet or a strane sign like >[0...9 )(*&[EMAIL PROTECTED]|?/<>,.] ??? > >any tips or help are most welcome! > >Regards >Wilbert Enserink This communication is for use by the intended recipient and contains information that may be privileged, confidential or copyrighted under applicable law. If you are not the intended recipient, you are hereby formally notified that any use, copying or distribution of this e-mail, in whole or in part, is strictly prohibited. Please notify the sender by return e-mail and delete this e-mail from your system. Unless explicitly and conspicuously designated as "E-Contract Intended", this e-mail does not constitute a contract offer, a contract amendment, or an acceptance of a contract offer. This e-mail does not constitute a consent to the use of sender's contact information for direct marketing purposes or for transfers of data to third parties. Francais Deutsch Italiano Espanol Portugues Japanese Chinese Korean http://www.DuPont.com/corp/email_disclaimer.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]