Topic: Need help with SELECT statement (ORACLE)

[iPixel]

I have a field called pnum and it contains numbers such as 7171, 1234, 6548,1695, 7186549872,2124856034,9854567336

and i want to SELECT FROM table WHERE pnum (does not exceed 4 characters).

I just want a list of all rows that containa  number like 1234  and not 7186549872

Thanks!

[F1Fan]

SELECT * FROM table WHERE length(pnum) <= 4