how i use string functions to write sql query

2314 · Oct 25, 2004

hi,
i want to select first two characters of a field using sql how do i do that

hoinz · Oct 25, 2004

substr(field,1,2)

2314 · Oct 25, 2004

HOW DO I CHECK WHETHER THE FIRST TWO CHARACTERS ARE NUMERIC

SantaMufasa · Oct 25, 2004

2314

As I mentioned in your other thread, 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)
@ 11:00 (25Oct04) UTC (aka "GMT" and "Zulu"),
@ 04:00 (25Oct04) Mountain Time