iPixel Posted April 26, 2010 Share Posted April 26, 2010 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! Quote Link to comment https://forums.phpfreaks.com/topic/199825-need-help-with-select-statement-oracle/ Share on other sites More sharing options...
F1Fan Posted April 26, 2010 Share Posted April 26, 2010 SELECT * FROM table WHERE length(pnum) <= 4 Quote Link to comment https://forums.phpfreaks.com/topic/199825-need-help-with-select-statement-oracle/#findComment-1048946 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.