# How can i do this? SELECT \* FIRST CHAR MUST ME NUMERIC

**URL:** https://forum.kirupa.com/t/how-can-i-do-this-select-first-char-must-me-numeric/169564
**Category:** Uncategorized
**Created:** [November 17, 2005, 9:36am UTC](https://forum.kirupa.com/t/how-can-i-do-this-select-first-char-must-me-numeric/169564 "2005-11-17T09:36:14Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![manga](https://avatars.discourse-cdn.com/v4/letter/m/6bbea6/32.png) [@manga](https://forum.kirupa.com/u/manga)
#### Post date: [November 17, 2005, 9:36am UTC](https://forum.kirupa.com/t/how-can-i-do-this-select-first-char-must-me-numeric/169564/1 "2005-11-17T09:36:14Z")

</div>

I want to select in a table all values that begin (SUBSTRING(column,1,2)) = NUMERIC??

how can i do this?

and also select the same values but not Numeric…?

Cheers,

M