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! 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 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
Archived
This topic is now archived and is closed to further replies.