Hi, try something like this:
"select [fields] from [table(s)] where [fieldtosearch] regexp "^([1-9]{1}|10)"; ~James <[EMAIL PROTECTED]> wrote in message 003901c200b2$27ccff40$0100a8c0@JohnH">news:003901c200b2$27ccff40$0100a8c0@JohnH... This isn't a one hundred percent PHP Q but here I go. If I have the following query: $query = "SELECT code FROM links WHERE ".$text." like '".$l."%' ORDER BY sort_text"; and define the letter a letter i.e x. it works fine. I am not sure what to do if I want to say get something that starts with (from one to ten). I want to say all the numbers at once, not one at a time. Any help appreciated, JJ Harrison [EMAIL PROTECTED] www.tececo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php