Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Select only if two character and two number

Select only if two character and two number

From: Sashafay <afayfman_at_mwh.com>
Date: 29 Jun 2002 19:16:40 -0700
Message-ID: <a13f8a22.0206291816.486c7e0a@posting.google.com>


I looking for the function (or some other trick) to identify new input in the table, that will be a combination of two character and two number only. But I don't know how to recognize if these input that what I looking for. In that field user can input any values (ex. ‘ABCD' or ‘1234') but I want only first and second characters and third and fourth numbers (ex. ‘AB12').

Thanks in advance,
Alex Received on Sat Jun 29 2002 - 21:16:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US