Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

HOW DO I CHECK WHERE THE FIRST TWO CHARACTERS ARE NUMERIC

Status
Not open for further replies.
2314

2314

Programmer
May 19, 2001
69
IN
HOW DO I CHECK WHERE THE FIRST TWO CHARACTERS OF MY FIELD ARE NUMERIC
 
Sort by date Sort by votes
2314

One method is:
Code: 
...Where translate(substr(<colname>,1,2),'^0123456789','^') is null...

Let us know if this does what you wanted.

[santa]Mufasa
(aka Dave of Sandy, Utah, USA)
@ 10:57 (25Oct04) UTC (aka "GMT" and "Zulu"),
@ 03:57 (25Oct04) Mountain Time
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
2K
carp
carp
Livia8
  • Locked
  • Question
How to forcibly logout users 2
Replies
17
Views
641
carp
carp
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in &quot;Description&quot; column of &quot;AP_INVOIC 2
Replies
5
Views
195
Livia8
Livia8
kernal
  • Locked
  • Question
Extract string before the first &quot;-&quot; it finds and the space prior to the &quot;-&quot;
Replies
5
Views
125
carp
carp
Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
323
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top