Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: test a column value
ji wrote:
> Hi:
>
> How can I test a column (datatype varchar2) value in Oracle 8.1.7, I need to
> find out this column contains a string of numbers (1,2,3...) or characters
> (a,b,c ...) in any position.
>
> much appreciate
Use the INSTR function.
Daniel Morgan Received on Mon Oct 28 2002 - 10:40:49 CST