First charactor should be number

newer · #1 (**permalink**) 06-29-09, 10:41

I want the query filter out first charactor that not be number

Field name is PRDNO, it could be 0102B, ab234 (filter out ab234)

select PRDNO
FROM file.lib
WHERE LEFT(PRDNO,1)=?

Thanks,

Lisa

tonkuma · #2 (**permalink**) 06-29-09, 11:36

There will be many ways.
For example:
WHERE LOCATE(LEFT(PRDNO,1),'0123456789') = 0

WHERE TRANSLATE(LEFT(PRDNO,1),'*',' 0123456789') <> ''

WHERE LEFT(PRDNO,1) NOT BETWEEN '0' AND '9'

tonkuma · #3 (**permalink**) 06-29-09, 11:52

Where Left(prdno,1) Not In ('0','1','2','3','4','5','6','7','8','9')

Internet Services

Web Development

Digital Marketing

Consumer Tech