# Sql statement help

**URL:** <https://www.ruby-forum.com/t/sql-statement-help/188899>\
**Category:** Rails\
**Created:** [May 20, 2010, 5:27am UTC](https://www.ruby-forum.com/t/sql-statement-help/188899 "2010-05-20T05:27:24Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![nirosh](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/ce7236/32.png) [@nirosh](https://www.ruby-forum.com/u/nirosh)\
**Post date:** [May 20, 2010, 5:27am UTC](https://www.ruby-forum.com/t/sql-statement-help/188899/1 "2010-05-20T05:27:24Z")

</div>

i need to find records which are starts with numeric values. So how  
can i write the sql query?

nirosh

---

<div class="post-metadata">

**Author:** ![nirosh](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/n/ce7236/32.png) [@nirosh](https://www.ruby-forum.com/u/nirosh)\
**Post date:** [May 20, 2010, 9:23am UTC](https://www.ruby-forum.com/t/sql-statement-help/188899/2 "2010-05-20T09:23:51Z")

</div>

On Thu, May 20, 2010 at 5:26 AM, nirosh [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)  
wrote:

> i need to find records which are starts with numeric values. So how  
> can i write the sql query?

Read the documentation on LIKE and regular expressions for your db.