| Syntax: translate(<string>, <from-translate-string>, <to-translate-string>) Example 1 A translate statement could translate 'ABCDEF' to '123456'. So an input value 'REAR DOOR' would become 'R51R 400R'. A select statement demonstrating this would be: select translate('REAR DOOR', 'ABCDEF', '123456') OUTPUT FROM DUAL; OUTPUT ----------- R51R 400R Example 2 The below example takes any inout values and deletes the alpha numeric and returns only numbers select * from pro.pro_parts_root where (stk_part_nbr like '00000%' and length(translate(upper(substr(stk_part_nbr, 6, 5)), '0123456789- ABCDEFGHIJKLMNOPQRSTUVWXYZ', '0123456789-')) != 5) |